Thanks to each of you for your response. They are all exactly what I was looking for. The client was thinking about moving the back-end data processing to a faster server -- not thinking about the coding changes that would require. Currently they are running everything locally -- it is not even running across a network.

Kenneth, you mentioned:
1. If sorting a table of 3 million records, never let Fox do it. IOW, don't do an index and copy it out, and don't do a SQL SELECT...ORDER BY. There are tricks to vastly cutting the time it takes to sort large tables.

Can you give me some hints in this area?

Thanks again,
Doug