Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Incredible performance degration behaviour
Message
De
14/01/2005 02:05:08
Walter Meester
HoogkarspelPays-Bas
 
 
À
13/01/2005 14:06:22
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
00976753
Message ID:
00977066
Vues:
40
Hi Fabio,

>The dogma:
>If a developer open 100 workareas is not VFP slow,
>but the developer is incapable, surely .
>We can do anything with max 10 workareas !


Well then classify me as incapable. I've got one or two forms that might contain 100 occupied workareas. Remember that if you're using local SQL views, you'll have one workarea for the view and one for each underlying table, rappidly increasing the number of workareas when opening more view.

In another instance, I've got a query designer that *might* generate a cursor for each column that is requested. If the users have a very complex query, the number of workareas might increase rapidly. It was exactly in this query designer where I spotted the problem. It was taking too much time to construct a result cursor out of several others as I found justifyable based on the code and number of iterations.

To be honest. I'd be seriously crippled with only 10 workareas. I've got queries that on their own already open 10 workareas.

Walter,
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform