HenryChanE
asked on
Access, Oracle or SQL Server
I'm going to write a DB application with VB4-32bit. There are about 30 users for this application. It performs some common business stuff such as stock keeping, invioice, PO, SO, Quotation, AP/AR, etc..
1) Which DB is the best for my situation ?Access, Oracle or SQL Server.
2) Any third-party (Not Microsoft or Oracle, their comparsion are not neutral) website shows the comparsion between these DBs ?
1) Which DB is the best for my situation ?Access, Oracle or SQL Server.
2) Any third-party (Not Microsoft or Oracle, their comparsion are not neutral) website shows the comparsion between these DBs ?
I second brunchey that Access is out of the question. Anything beyond ten users gets dicey. If price is no option, Oracle is the best. Oracle is much more expensive, but will perform better on any particular server. SQL Server, however, give a lot of "bang for the buck." I have small workgroups (<10 users) running on single processor Pentium 100s. Large groups work well on multi-processor servers. One note with either Oracle or SQL Server: put more RAM on your server than you think you would ever use. It is a cheap investment with great paybacks in performance.
With the number of users you are proposing, and the type of application, performance is something you can buy with hardware. Which is the absolute best? Oracle, hands down. You need to decide whether the extra cost is worth it.
With the number of users you are proposing, and the type of application, performance is something you can buy with hardware. Which is the absolute best? Oracle, hands down. You need to decide whether the extra cost is worth it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
mshowell,
It seems that SQL Server is the best out of three. Can you give me some contact info. about the Accounting package source code? I've just heard about "Intech Software"(www.generaloffice.com), but it's fit my needs very much. THANKS !
It seems that SQL Server is the best out of three. Can you give me some contact info. about the Accounting package source code? I've just heard about "Intech Software"(www.generaloffice.com), but it's fit my needs very much. THANKS !
http://www.dbmsmag.com