I never saw any situation which requires to load 10,000,000 rows at a single time in a program! That's what you need to work on in order to speed up your process!
>Thanks and I got other question: I have table with a lot of records (+/- 10,000,000 records) .. when I run "Select * from Daily" it takes very long for loading .. do you have any idea for speed it up?
>
>mSQL="Select * from Daily"
>rsData.open msql, cndata, adOpenKeyset, adLockReadOnly
>rsData.movelast
>
>do you have any suggestion?
>
>Thanks again
>
>Winanjaya
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com