Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unexplained Select - SQL delay
Message
From
21/12/2006 14:15:25
Spencer Redfield
Managed Healthcare Northwest, Inc.
Portland, Oregon, United States
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01178661
Message ID:
01179633
Views:
9
Thank you for this suggestion and all of your kind assistance. That syntax suggestion does not appear to offer a speed advantage over the syntax I'm looking at.

Resolution:
Our testing indicates that we can get back to the fast responses by, one at a time, ZAPing the tables in the "fast" development .DBC and importing the production data. The resultant .DBC then works normally on both our development and production servers.

After close of business we'll run this process for "real". By morning we expect to be back to normal.

Conclusion:
We have an empirical solution but, despite some efforts, have not pinpointed the problem's actual source.

Thanks again to all for your very kind assistance.

Spencer
Previous
Reply
Map
View

Click here to load this message in the networking platform