Explination of how ADODB deals with a large number of records 
Author Message
 Explination of how ADODB deals with a large number of records

If you have say 10,000 record in a table in your database and your ADODB ASP
runs the following:

sql = select * from TheTable
Set RS = Session("DBConnection").Execute(sql)

do all 10,000 records get retrieved in one shot?  Or is there a procedure
ADODB uses when working with large amounts of data?  If anyone knows the
{*filter*}details, I would appreciate a brief explanation.

Thanks in advance.

Nelson Beaman



Tue, 13 Feb 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Inserting large number of records into a large table with SQL/DAO

2. Trouble retrieving a fairly large number of records from a database

3. MS SQL Server, ADO, Large Number of Records, timeout

4. can the loading of a large number of records go as quick as in DOS

5. Creating adodb.record from Adodb.recordset

6. Managing/processing a large number of large arrays

7. Dealing with large procedure bodies (Another method?)

8. Dealing w Very Large Character Set ??

9. How to deal with Windows LARGE Fonts?

10. Help dealing with large tables/recordsets.

11. Dealing with large Fonts

12. Dealing with LARGE Font Desktops

 

 
Powered by phpBB® Forum Software