MB Software Solutions wrote:
> Ed Leafe wrote:
>> First off, this is a view, which means that you shouldn't have a ton
>> of records. My guess is that a LOCATE even without indexes will be
>> plenty fast.
>>
>> Are you seeing delays that are causing you to pursue this?
>>
>>
>
> Not exactly delays, but just tons of iterations. There are 600+ records
> that go through this routine (which thankfully isn't called too often).
You might try a SELECT statement combining your 600 records with the
view. You write it so that it will return those records that match or
those that don't match or their quantities depending on your needs. That
might speed it up a bit (maybe).
For example :
SELECT MyView.* ;
into cursor CrsrFoundItems ;
from MyView V;
inner join My600records R;
on V.RecType = R.RecType ;
AND V.iKey = R.iKey ;
where V.JobID = this.nJobID
and now you process your hits.
SELECT MyView.* ;
into cursor CrsrFoundItems ;
from MyView V;
left join My600records R;
on V.RecType = R.RecType ;
AND V.iKey = R.iKey ;
having isNull(R.RetType) or V.JobId # this.nJobId
and now you process you misses.
> I used Markus Egger's Coverage Profiler add-in tool to show me what code
> is slow and running lots of times. This was brought about by a
> significant delay in the start of a process.
>
> Unfortunately, I think this is just the way it has to be for this
> situation's particulars (without going into client detail).
>
> Ever get times where you think you're writing butt ugly code and should
> just stop for the night? <g>
>
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
