How to retrieve 2 million records with ADO recordset???

[Ertan Zanagar]

I need to get a total of about 2 million records with one select statement
into my ADO recordset.

What is the best way to do this? Is it not a good method to load that many
recordsets into one recordset? I know there is a way where I can load "x"
number of records at a time and as I iterate through my recordset and when I
reach the end of recordset, it fetches another "x" number of records until I
hit the end of the collection.

Any suggestions?

Please reply directly to my e-mail account er...@zanagar.com

Thanks in advance.

E.Z.

[Bruce Thew]

I can't even imagine Why anyone would need to get a recordset of 2 million
of anything. The best way is to make your SQL statement exact so it only
returns what you need. Remember the best recordset is one that contains one
record.

"Ertan Zanagar" <ezan...@yahoo.com> wrote in message
news:gskI5.104676$g6.47...@news2.rdc2.tx.home.com...