Just a reminder of how important it is to have the right index tags.

We use TIW's WorkShop (factory management) and the AccPac 6.0 accounting software both of which are written in VFP along with several home grown VFP6 apps that I have developed over the past 9 months. One of these produces numerous reports (mostly regarding production) pulling data from WorkShop, AccPac and other data tables that we have created. The queries of many of the reports have been executing very slowly taking 30 to 45 minutes in some cases. I isolated the problem to a particular transaction history table in the WorkShop application. I noticed that the current transaction table, SOTran, had 4 index tags while the corresponding history transaction table, SOyTran had only one index tag. Many of the queries done in producing the reports did joins on the SoNo field (sales order number) and the SOyTran table did not have an index tag on this field.

When I added an index tag to the transaction history table for the SoNo field, the results were spectacular indeed. Reports that took 30-45 minutes now execute in less than 10 seconds!

Ah, The Power of Rushmore