Advantage Developer Zone


Maximizing Performance when Converting Paradox Data to Advantage

Friday, July 14, 2006

It is important that an analysis be done of the filters and queries that are used in a given application. The goal is to find out what fields are used in the filters and in the WHERE and ORDER BY clauses of the SQL statements. Once you have that information, you can create simple indexes for each field used in the queries and filters. In addition, you can create indexes that directly relate to your ORDER BY clauses. With that completed, the Advantage queries and filters can run several times-even hundreds of times faster than without them