Hello folks,
I'm fairly new to Pervasive (coming from SQL Server background). Is there any way to tune the performance of a table? I have a table that has a relatively low number of records (~1000), and I'm doing some simple selects against it. The queries always take a long time to execute. Other tables in the system seem to respond pretty good, depending on their size, but this one seems to be excessively slow.
Any ideas on where I might start looking for the problem?
Thanks
I'm fairly new to Pervasive (coming from SQL Server background). Is there any way to tune the performance of a table? I have a table that has a relatively low number of records (~1000), and I'm doing some simple selects against it. The queries always take a long time to execute. Other tables in the system seem to respond pretty good, depending on their size, but this one seems to be excessively slow.
Any ideas on where I might start looking for the problem?
Thanks