Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ConnectionString for SQLServer
Message
From
03/03/2004 20:14:10
 
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00882578
Message ID:
00882960
Views:
16
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform