VFP can make up for a lot, e.g., missing indexes, when the numbers are small enough so that data can be cached in memory. And then everything goes to heck, and you're wondering why.

Hank

>Thanks for all the suggestions.
>
>Usually processing time takes a few minutes, but this person has put in lots and lots of data, and hence it now takes forever.
>
>I am sure there is room for code optimization.
>
>I thought I might get some immediate improvements by tweaking the hardware settings first. Doing some testing now based on the suggestions received.
>
>Cyril
>
>
>
>>It's Coverage Profiler time: download CVP (google on CVP VFP Profiler) and find out what is slowing you down.
>>
>>Hank
>>
>>>Are there any hardware settings one can make to improve performance?
>>>
>>>I have a routine that takes 58 minutes to run. A user bought a new 2 Core Centrino laptop in the hope that it would shorten the processing time. The time went down from 58 to 53 minutes - not much of an improvement.
>>>
>>>Are there any hardware settings worth suggesting to her?
>>>
>>>What settings should I tell her to change, (or hardware to buy) to gain some quick speed improvements?
>>>
>>>Cyril