>Hi,
> I am using SQL to query records from a big table. VFP need 4 secs to retrieve 4 records out of 20,000 records with FULL OPTIMIZED under 100 BASET Network. Is it acceptable? Any way to impove?
>
>Thank you
No, it is definitely not acceptable if SYS(3054) shows full optimized. Try to reindex your table. If it does not help, try to drop and recreate the indexes.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison