PDA

View Full Version : So much data,



mfc2themax
10-13-2001, 05:35 AM
Im working on an N-Tier distributed web application thats made with COM+ (written in VC++). I've developed data access components for SQL Server, Access, Oracle, MySQL, and DB2 im trying to find the highest performance database that will be used default with the app. Theres gonna about 100,000 user records stored in the database, along with tons of other info. Another server will house a database that will store user state information (persistance state), and the app will frequently read/write to the database.

Any suggestions on which database i should go with, based on performance?

mfc2themax
10-13-2001, 05:39 AM
its not letting me edit my post, but instead of saying user state information, it should say user session information....

anyways, any ideas on a good database?

Garfield
10-13-2001, 06:53 AM
Um...I usually work with Access. I'm not really sure how it will work with that much data, though. It could become unstable. But I've never run into that problem.