Pervasive 2.04 uses 100% cpu on Citrix

[navarac1]

Hello,

When my users print a work order from Dynamics an ODBC connection is made to the btrieve database using Pervasive 2.04. I've noticed that the executable w32ssql.exe uses 100% of the cpu in order to accomplish this but when the work order has completed the cpu remains at 100% with w32ssql.exe at the top of the list. Needless to say this slows the system down considerably.

Any ideas would be greatly appreciated.

Steve Smith

 

[mirtheil]

What's the SQL statement that's being generated? You should make sure that the statement is optimized.
Once the statement has finished running, the CPU utilization should drop back a normal level.
info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician