Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Lesser records to retrieve - longer time?
Message
De
20/06/2006 15:38:29
Mike Yearwood
Toronto, Ontario, Canada
 
 
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 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01130252
Message ID:
01130345
Vues:
22
>>>Hi everybody,
>>>
>>>The queue assignment process usually takes ~ 1 min., except for UNASSIGNED BILLER, where it takes ~10 minutes.
>>>
>>>Now, I speculated, that the reason is that we have only small amount of UNASSIGNED BILLER records comparing with other types.
>>>
>>>Can you help me to justify this theory in "scientific" form or do you think I should try to find the bottleneck using Coverage Profiler instead of guessing?
>>
>>The grid itself demonstrates problems with large tables and filters that show few records. Use of non-rushmore-optimizable commands with rushmore optimizable filters also have such problems.
>
>In this particular case we're talking about SQL that retrieves small amount of records using indexes. There is no GUI involved to contribute to the problem.

GUI wouldn't be required in case of SET FILTER and GO TOP. If its a SQL and not one that became a SET FILTER, then no. Your theory is not justifiable.

The optimizer tends to get it right. In those cases where it doesn't you can FORCE the joins.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform