Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unexplained Select - SQL delay
Message
From
18/12/2006 15:23:37
 
 
To
18/12/2006 15:13:23
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:
01178681
Views:
17
>Thank you for your prompt reply but, here, Rushmore is simply not the issue.
>
>No fields that would be involved with Rushmore optimization have been changed . Additionally the query itself is completely unchanged.
>
>Something else is going on to cause this for no obvious (to us) reason. Other ideas?

Well, I just wondered: if it's not Rushmore optimizable then VFP scans whole table, and if, for some reason, disk fragmentation got bad (i understand it's a big stretch) then something could change.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform