Re: Pervasive SQL - Timeout
I had similiar issues with version 7 of pervasive and usually got a
performance boost when i did the following:
Make sure that there is an index built upon any fields that you want to
filter on.
Create a stored procedure with the select statement in it.
Call the stored proceedure from your ODBC connection.
Don't know if the OBBC interface is improved in version 9 or not, but I
stay well away from it and try to use it for very little if at all,
thus the compiled stored proceedure.
-Henry
.
