How can the performance of an sql statement be improved?

Known circumstances which decelerate the process extremely:

1. Unfortunately is the Jet Engine of the most tools the reason for a slow performance in the ODBC part. The Jet Engine restructered the SQL statements in several small statements before passing it to the ODBC driver. The solution is to use "Pass Through" SQL statement. With this the PARKWAY SQL engine will be used instead of the Jet Engine. This can raise the performance rapidly. It is important to write the SQL statements in ANSI SQL standard, only this is supported by ConnectWare. Tools like MS Access uses their own SQL, this is not compatible.

2. The ODBC trace is activated.
3. The SQL query is expressed unfavourable, e.g. no key values when linking with Joins.
4. The data is located on another PC to which the connection is very .
5. There is not enough space on the system software drive for the swap file.

Further procedure:

- cheking the known problems above and solving them

- executing the query with another tool to get information on the dependency of the used components.

- executing the query on a local drive to get information about network dependency

For more help please contact the PARKWAY Support