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 |
|
agniwoni
Starting Member
28 Posts |
 Posted - 2007-10-09 : 09:29:30
|
| When You declare an ADODB.RECORDSET (RS) variable (for ex. in VBA), and You open it with a select statement, retrieving some big table straight into the RS,and (for ex.) You write to a XLS sheet data from this recordset:where physicly are data from recordset? - In ram memory (as much of them as the ram can handle to contain)?- In SQL server, and the RS is just a "bridge" between SQL srv and the destination?- else?Regards,Agniwoni |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-10-09 : 09:40:17
|
| 1. Yes it remains in the RAM, but depending on the setting of CursorLoation property it can either reside in Server or Client memory.2. How many records are fetched in RAM is decided by the CacheSize property.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
agniwoni
Starting Member
28 Posts |
Posted - 2007-10-09 : 10:00:52
|
quote:
Originally posted by harsh_athalye
1. Yes it remains in the RAM, but depending on the setting of CursorLoation property it can either reside in Server or Client memory.2. How many records are fetched in RAM is decided by the CacheSize property.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED"
Thank you very very very much,kind regards!Agniwoni |
|
|
|
|
|
|
interesting ADODB.recordset question