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).
> 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>
Can you bring the data into your view in a presorted way instead?
Stephen Russell
DBA / .Net Developer
Memphis TN 38115
901.246-0159
"A good way to judge people is by observing how they treat those who
can do them absolutely no good." ---Unknown
http://spaces.msn.com/members/srussell/
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.11.8/940 - Release Date: 8/6/2007
4:53 PM
_______________________________________________
Post Messages to: [email protected]
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.
