Access 97/Pervasive SQL 7 ODBC

[RippleJD]

I have an access program that links to Pervasive SQL 7 tables via ODBC. On one PC the performance is adequate. On another, the performance is much too slow. The only difference between the two PCs (as far as I can tell) is that the "slow" pc had Windows 98 and the "fast" pc has Windows 98 SE. I upgraded the "slow" pc to Win 98 SE, but it did not help. Any other suggestions?
X-)

 

[DougP]

Access is great but it loads everything into RAM
And it drags everything accross the network instead of just what it needs (Its not Client/Server)

ODBC depends on several things to work fast or faster
RAM, CPU speed, Network Bus speed

best fits are
128 Meg RAM
600 Mhz ^
100 Base-T DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[MichaelRed]

Get your org to adopt a real database with actual support. Pervasive is - IMHO - not in the same league as even SQL Server. It is - again IMHO not even as 'good' as Ms. Access. So why pay extra priemium for inferior products?

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[taozero]

I too am having this problem linking to a Pervasive.SQL v7 SP4 database on a WinNT server through Access97 using the Pervasive ODBC-32 v2.54 Driver. The performance bottleneck occurs when first launching Access and opening a table or query. The 'slow' machine takes ~90sec to load the data, the 'fast' machine takes 3-5seconds. After getting past this initial delay the application on the 'slow' machine responds fine. The 'slow' machine is a PII-333Mhz w/384MB Ram, the 'fast' machine is a PIII-733Mhz w/256MB Ram with both running Win98SE. Granted there is a hardware difference here but should it be this pronounced? Is there a registry key or setting I am missing?

 

[MasterPO]

I've noticed extreme slowness when running 'Select' queries against large Btrieve tables using the Pervasive ODBC Driver. I have a couple of suggestions that may help you:

1. Use a Make Table query to bring the dataset locally into Access, then do what you need to (Reports, etc). Make table queries operate extremely quickly, even on a slow machine, while the 'Select' queries seem to bring the machine to it's knees.

2. Use the ODBC drivers from Data Direct (used to be Merant / Intersolv). They are much faster than Pervasive's and seem to handle Access better.

 

[taozero]

Thanks for you help. I did run the eval version of the the Data Direct driver (

http://www.datadirect-technologies.com/)

and saw the access time for the 'slow' machine go down from 90 seconds to just under 3 seconds! Problem solved!