Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select in VFP too Slow
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL Select in VFP too Slow
Miscellaneous
Thread ID:
00423852
Message ID:
00423852
Views:
67
I have a Database with a Table that have 198,000 records with people names and ohter information ?

I need to retrieve a field from this table:

I'm using the next sintax:

SELECT * FROM DATABASENAME!TABLENAME WHERE TABLENAME.FIELDNAME;
LIKE "%NAME TO FIND%"

OK, THIS WORK THE "NAME TO FIND" RETURNS BUT:

THE RECORDS RETURN VERY LOW:

1ST run of the instruction: 29.220 sec (ok Good Time)
2nd run of the instruction: 145.93 sec (What Happen)
3rd run of the instruction: 120.26 sec (???)
4th run of the instruction: 124.20 sec (???)
5th run of the instruction: less than 2.000 sec (Excelent)
6th run of the instruction: less than 2.000 sec (Excelent)

How could I speed the 4th first searchs ??

Thanks and sorry for my english.
Next
Reply
Map
View

Click here to load this message in the networking platform