Pervasive Performance Help

[fwadmin]

I am developing in VB6(sp5) and connecting to a database on the same machine via the pervasive 2000i workgroup engine. The performance is terrible using ADO through both ODBC and OLEDB. The same queries on an Access2000 database run 10 times faster.

I have noticed that using ODBC through a DAO connection performs very well but Microsoft is phasing out support for DAO.

I even went as far as creating an Access database with nothing but linked tables to the Pervasive tables and this performad very well also (but I think Access uses DAO for this).

How are you guys making your database connections with reasonable performance?

For example, a simple select and traverse of 2100 rows shows the following:
ADO/OLEDB - 8.5 seconds
ADO/ODBC - 12.3 seconds
DAO/ODBC - .38 seconde
Access Linked to Pervasive - .67 seconds

Thanks for any advice.

 

[Linda84]

Have you checked out the "Best Practices with PervasiveOLEDB" paper on our website at

http://www.pervasive.com/support/TechPapers.asp?

It has a number of suggestions related to performance.