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> -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ 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.
