Access vs. SQL 7.0 speed

[bwysocki]

We developed a Visual C++ application that uses either a MS Access 97 database or MS SQL Server 7.0. We notice that accessing data is noticably slower using SQL compared to Access. Are there any suggestions to increase the performance with SQL?

 

[rtshort]

I'm too new at it to tell you, but I know that SQL Server will handle more users at one time than Access. If you don't have over 10 users at one time and Access is faster, then I'd use access myself. However as the database grows, you may see access begin to slow down. Rob
Just my $.02.

 

[jjgraf]

If the access database is on the same machne where the app is running yes you will see a faster dataaccess. If access is on a Network drive I'm suprised to see better performance.

If sql is on the same machne with the application i'm not surprised to see a performance hit. Sql is its self an application that is a resource hog, your applicatin is eating up resources, plus you have the OLE DB layer. So you have slower speed.

Access would not suffer from the above problem because the data engine lives in the application memory space.

Access is one of the worst databases in the world why are you using it.