Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Query executes too long
Message
De
08/07/2001 03:35:19
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00527693
Message ID:
00527866
Vues:
37
This message has been marked as a message which has helped to the initial question of the thread.
>Don't think, it would help. Actually, I think there was another problem there, which I didn't remember at the time, I wrote this message. When I connected our server through PCAnywhere, I got a message, that the server is running out of space. I ignored it and continued my work, but it might be a reason for such slowness.


Yes, that could cause your problem. You should never fill a disk more that 80%, to guard against weirdness. Are your working files on the server or workstations(set in the config.fpw)? If the are on the server, make sure there is physically enough contiguous space to hold the queries. Also, it can be faster to have the workfiles sent to the workstation, depending on how your server component is running.

I assume that each of the fields being joined and/or filtered on are indexed (including deleted). If not, that may also help.

Also, you said something to the effect that you don't like the idea of breaking up the query into multiple subqueries, because it is inelegant. I agree with you. However, an inelegant application that runs is still more functional than an elegant application that doesn't...
EMail: danielj@ryte-byte.com
"If I'm paddling so hard, how come I'm going backwards?" - Pinocchio (while the whale was swallowing him...)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform