>I have made the change to the SQL Select and use WHERE instead of TOP (I had to get the last number first) and the speed of getting the query is 100 times faster. Hopefully when I switch to SQL Server I will find a method to find the last PK value quickly too.
>
>>The SYS(3054) can only report on WHERE and JOIN optimization. I'm not sure if VFP is capable of optimizing anything else.
>>
>>>
If you needed to get record with the last number, then take a look here
Including an Aggregated Column's Related ValuesIncluding an Aggregated Column's Related Values - Part 2
If it's not broken, fix it until it is.
My Blog