Query processing related to cursor and recorset commands
Q1. Assume our query is first. Nothing is in cache.
a) on cursor open: all records satisfying query are read from the file
into temporary buffer on the server
b) on fetched: data is moved from the buffer to a clien/client t application
Q2. The same, but it is recordset specific
How is query process related to recordset commands?
oRS.Open and oRS.MoveNext
a) all records satisfying query are read from disk into temporary memory
buffer on the server
( if they are not in cache)
b)on MoveNext they are fetched to a client/ a client application
a) list of pointers is built into server memory/tempdb that contains the
of datapages in the database file on the disk.
b)on MoveNext data is sent from server memory to the client memory
Any references/links are welcome
Thank you in advance,
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL