Dear All....
I wanna ask something to all of you who can help me...
I develop my project using VB 6.0 and SQL Server 7.0 for my database.
My project is to transfer / convert data from .DBF table to SQL Server 7.0 database.
One of my .DBF table is named by CUT3.DBF, and it has 430.500 records.
So, when I opened it using ADO Connection, it runs very slow.
Here is my SQL Statement to open it :
MyConn.Open "DSN=dbfConn"
MyRec.Open "select * from CUT3 where pl_no = '" & Trim(tmpJobNo) & "'", MyConn, adOpenDynamics, adLockOptimistic, adCmdText
So... I want to ask to all of you who knows about this.....
"Why my SQL Statement above run slow on 430.500 records ?"
and
"Anybody knows how to make it faster ?"
Thx, all....
Best Regards,
Wen Lie
