Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Lesser records to retrieve - longer time?
Message
From
20/06/2006 11:37:22
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01130252
Message ID:
01130268
Views:
15
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform