I would first look at the queries. Are they SQL, SCAN...ENDSCAN, or DO WHILE...ENDDO?
Then I will look at indexes, notably the index expressions. Make sure that they are Rushmore-optimized! On Fri, Apr 24, 2015 at 1:30 AM, Gene Wirchenko <[email protected]> wrote: > One of the options is whether to process non-contract work orders. > When they are processed, there are 82581 records to refigure in my test > data. When only contract work order transactions are refigured, there are > only 73073. These test records are in a cursor. Due to the differing > record counts, I expect that there should be about a 10% difference in the > times, but the processing time for the two situations is nearly identical! > What gives? > When I abbreviate the data selected to about 9,000 records, the > processing is correspondingly faster, but why the plateau with the larger > datasets? -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you! _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAGv=mjc2ix6xpwo2m8djpzedpz3r+jzagkcpjd1tkvra0sm...@mail.gmail.com ** 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.
