Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unexplained Select - SQL delay
Message
From
20/12/2006 12:58:05
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:
01179282
Views:
10
Perhaps you might give me guidance on this one question. It is:

Specifically what, other than 1) tags, 2) keys, and 3) collation sequence, are documented factors in revealed SYS(3054) showplans' differences?

We are still unsuccessful in solving this issue.
1) LIST STATUS indicates that, in both instances, all of the tags and their collation sequences are identical.
2) Both .DBCs, "development" and copy of "production" data, are on the same server.
3) Both have close to the same number of records.
4) The SELECT - SQL expression ran adequately for years and is unchanged.
5) The "development" data completes in approximately 0.015 seconds 
   (as did the production data until last week).
6) The "production" data completes in approximately 23.6 seconds
Thank you for all of the kind help you have given.

Spencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform