|
Or instead of modifying the program(s) that maintain the detail file, put a trigger on the detail file to maintain the summary. Or an SQL view? Any of these solutions result in spreading the hit out over the maintenance versus the run of the report. And if the maintenance is done via user interaction one additional chain/update in between presses of the enter key will be unnoticeable on any machine bigger than a B10. Rob Berendt
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.