General discussion

Locked

Access vs other DB applications

By davegenovese ·
In terms of speed and available memory, what is the best DB application to use? I need speed & the ability to store quite a bit of info. I believe Oracle would be the best, but I would like to get a second opinion.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access vs other DB applications

by Glen_McLeod In reply to Access vs other DB applic ...

Define what you mean by 'quite a bit of info'. Access is a *desktop* database and is not meant for gigabytes of data, but functions reasonably up to the low hundreds of megabytes.

Is this a multi user system? For anything over 6-8 users, forgetabout Access and move to a server based DBMS such as SQL Server or Oracle. However, you then have the costs to consider, and neither is cheap, although SQL Server *is* reasonably priced in compairason to Oracle.

There is a desktop version of SQLServer that ships free with Access 200 and above, called MSDE. It's more robust, smarter and can handle more connections than Access, up to *about* 25.

Glen

Collapse -

Access vs other DB applications

by davegenovese In reply to Access vs other DB applic ...

The question was auto-closed by TechRepublic

Collapse -

Access vs other DB applications

by SpikeyMike In reply to Access vs other DB applic ...

If you have the budget, go with some big iron (multiple CPU, lots of RAM, SCSI RAID 5) and get a Sybase, Microsoft, Oracle solution. If money is tight, take a look at Sybase's Adaptive Server Anywhere (formerly known as SQL Anywhere). It is a small footprint and fully-capable remote database.
Regards,
-Mike

Collapse -

Access vs other DB applications

by davegenovese In reply to Access vs other DB applic ...

The question was auto-closed by TechRepublic

Collapse -

Access vs other DB applications

by r_isles In reply to Access vs other DB applic ...

In terms of RDBMS applications, MS SQL Server and Oracle will do the job for you. I wouldn't suggest having MS Access since it can only handle 255 concurrent users as compared to let's say MS SQL Server's 32,767! If you want your applications to scale for a very large number of users, I wouldn't suggest using a file-based Database application like MS Access.

Collapse -

Access vs other DB applications

by davegenovese In reply to Access vs other DB applic ...

The question was auto-closed by TechRepublic

Collapse -

Access vs other DB applications

by davegenovese In reply to Access vs other DB applic ...

This question was auto closed due to inactivity

Back to Web Development Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums