Recordset performance problem.

[bwysocki]

Using VC++ 6.0 we are currently writing to a MS SQL Server 7.0 table that we have opened as a snapshot recordset. As more records get put into the table, the performance of our routine goes way down. Is there a way to improve performance with working with big tables? Would dynaset be better than snapshot?

Any help you can give would be appreciated!

 

[Sawatzky]

dear bwysocki,

what amount is 'more'?

a snapshot recordset is actually meant to be a local copy to analyse the data, for update or insert you should prefer a dynamic one .

the performance of a statement often depends on the amount of linked tables involved in the query.

regards Astrid

 

[rpet]

Astrid is correct on this. The sql-server performance depend on your database design - much more than on the amount of data.

Search the MDSN, you will find a lot of useful information about this topic, e.g.:

http://support.microsoft.com/support/kb/articles/Q110/3/52.asp

Regards
Ralf