Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-20 : 22:56:06
|
Scott writes "If the cachesize on a server is set to 1, and you do a select that returns 100 rows, is a db2 read of the table preformed everytime a movenext, movefirst, eof, etc check is performed?
According to this page:
http://www.learnasp.com/learn/whygetrows.asp
rst.GetRows should be used (to move records into a string) rather than doing a rst.movenext to keep from doing a db2 read of the table. Microsoft seems to agree on this according to one of their performance pages for ASP, but one of our dba's doesn't think that a read is done every time - even with the cachsize set to 1.
Anyone have thoughts on this?
Thanks,
Scott" |
|
|
|
|
|
ADO DB2 Reads and Cachesize