Using an ODBC-enabled application

When using an ODBC-enabled application to access a Synergy database, keep the following in mind:

Optimizing with pass-through queries

One way to optimize performance when using Microsoft Access is to use pass-through queries, which are queries that are passed directly to the database server. If you use a pass-through query, the database server does all the processing and returns only the result of the query. This bypasses the Microsoft Jet database engine. The reason this can improve performance is that Jet is key-based. So, for example, if you have the SQL statement “SELECT * FROM part”, Jet will first read all the keys; then it will perform a series of sequential statements like the following:

SELECT * FROM part WHERE part.number = <key>

For simple queries, this can result in many duplicate reads, making a pass-through query the more efficient alternative.