|
On Thu, 18 Aug 2005, Booth Martin wrote:
Or use an Input primary on the new logical, breaking on the key fields, and writing a summary record at L1 time. Fast, very fast.
And how are you to know what the ranges of high/low are using this technique? I suppose you could have an L2 on the suffix, and save the L1 detail value, then write the summary record at L2 total time....
But, if there are 1000 records in between the low suffix and high suffix, you'd have to read 1000 records to get one range. My technique requires you to read 2! Wouldn't you think that would be faster?
I guess, it depends on how many records are in range. If he really wants to know which is the fastest, he'll have to do it different ways and compare the results.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
