Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Performance Issue
Message
From
21/08/2009 18:06:46
 
 
To
21/08/2009 15:07:27
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01419605
Message ID:
01419691
Views:
96
>The slowdown occurs with a simple locate for contacts.custno="78113"
>I have reindexed all tables and removed deleted records

try
locate for contacts.custno=="78113"

lookup(contacts.custno,"78113",contacts.custno)
Previous
Reply
Map
View

Click here to load this message in the networking platform