Web Development

Ask something
Discussion Locked

Access vs other DB applications

0 helpful
7 replies

by davegenovese

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

7 replies

by glen_mcleod

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

by spikeymike

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

by r_isles

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.

This discussion is closed to new replies.