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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only