Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VB 6, MS Access 97 and ADO... what is best connection?
With all due respect to kb244, I must take exception to his answer. Even though MS claims that ForwardOnly is the fastest cursor type, I have found that this is NOT always the case. Unfortunately, the only way to find out which is really the fastest access method in any particular situation is...- Dragon55
- Post #4
- Forum: Visual Basic (Classic)
-
Why is ADO so much slower than DAO?
Thanks for your input, mohmehran, but as you can see in the rs.open statement, it is opened as Static. And I didn't specify the LockType because adLockReadOnly is the default. As for the grid I'm using, it's the new DataGrid control, which definately accepts ADO data sources. I would expect...- Dragon55
- Post #5
- Forum: Visual Basic (Classic)
-
Why is ADO so much slower than DAO?
OK, I was able to get the time down to 16 seconds with the following code: Option Explicit Private cnWIP As ADODB.Connection Private rsWIP As ADODB.Recordset Private Sub Form_Load() Dim sConnStr As String Dim sSQL As String Set cnWIP = New ADODB.Connection Set rsWIP = New...- Dragon55
- Post #3
- Forum: Visual Basic (Classic)
-
Why is ADO so much slower than DAO?
I am considering upgrading my VB6 apps to use ADO and Jet4.0. I have always used the generic data control up till now. So I made an Access 2000 version of one of my (replicated) databases and tried several methods of accessing the table to be diplayed in a DataGrid. (31,000 records, 26 fields)...- Dragon55
- Thread
- Replies: 8
- Forum: Visual Basic (Classic)
