Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Unexplained Select - SQL delay
Message
De
20/12/2006 12:58:05
Spencer Redfield
Managed Healthcare Northwest, Inc.
Portland, Oregon, États-Unis
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
Visual FoxPro
Divers
Thread ID:
01178661
Message ID:
01179282
Vues:
11
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform