New topic: ADO faster : how?
<http://forums.realsoftware.com/viewtopic.php?t=29195> Page 1 of 1 [ 4 posts ] Previous topic | Next topic Author Message forisco Post subject: ADO faster : how?Posted: Thu Jul 23, 2009 2:59 pm Joined: Thu Feb 07, 2008 2:21 pm Posts: 165 Location: Italy I use ADO with MS Access database (.mdb) but i noted a slowness with the large archives. I use the default ODBC driver 'Microsoft Access Driver (*.mdb)' in Windows Vista. It's possible to use a different (and faster) driver to read the mdb files? What are the fastest drivers (ADO and not ADO)? Bye _________________ RealBasic 2009 Release 1 Standard Edition on Windows Vista SP2 and on Windows 7 Beta 7000 Database Engine : ADODB (Microsoft Access MDB) - Report Engine : RPDF Top sphauck Post subject: Re: ADO faster : how?Posted: Thu Jul 23, 2009 3:29 pm Joined: Tue Jul 31, 2007 1:35 pm Posts: 38 ADO does not use ODBC at all, it a technology called OLEDB. OLEDB will be faster than ODBC because it is as native as you can get with Access. You can also do some things with OLEDB that you cannot with ODBC. There is a windows specific example included in the install Dim adodbConnection as new OLEObject( "ADODB.Connection" ) Dim adodbCommand as new OLEObject( "ADODB.Command" ) Dim adodbRecordSet as OLEObject Dim adodbFields as OLEObject Dim adodbField as OLEObject Dim connectionString as string Dim iter as integer Dim fieldCount as integer connectionString = "DRIVER={Microsoft Access Driver (*.mdb)};" connectionString = connectionString + "DBQ=ADODEMO.MDB;" connectionString = connectionString + "UID=admin;PWD=;" adodbConnection.Open( connectionString ) Top forisco Post subject: Re: ADO faster : how?Posted: Thu Jul 23, 2009 3:54 pm Joined: Thu Feb 07, 2008 2:21 pm Posts: 165 Location: Italy Thank you, sphauck. I use exactly that you suggested! And i have only a database with tables to accelerate the queries but it's slow! Others suggestions? _________________ RealBasic 2009 Release 1 Standard Edition on Windows Vista SP2 and on Windows 7 Beta 7000 Database Engine : ADODB (Microsoft Access MDB) - Report Engine : RPDF Top sphauck Post subject: Re: ADO faster : how?Posted: Thu Jul 23, 2009 3:56 pm Joined: Tue Jul 31, 2007 1:35 pm Posts: 38 More information would be necessary to help further. How much data? What does the table look like? What do your indexes look like? Have you compacted the database recently? How are you inserting, are you looping through a text file and importing the data or is it a calculation of some sort? Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 4 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
