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:
01130271
Views:
19
>>>>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?

I haven't tried it yet. Right now I'm running the whole process with Coverage Profiler to confirm my theory about this query being the one to blame.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform