Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Lesser records to retrieve - longer time?
Message
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:
01130269
Views:
17
>>>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?
>>>
>>>Thanks in advance.
>>
>>I think you shoud find the bottleneck.
>>Cetin
>
>Thanks <g> I will do it now.

What SYS(3054) said about this SELECT?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform