|
It's a little faster (maybe 15%)... but still slow. Brad On Wed, 9 Jan 2002 13:06:11 -0500 "Mangavalli, Ramanujam" <RamM@Mvmills.com> wrote: > I am not a Java guru, but can't you use a single SQL > statement something > like > > SELECT COUNT(*), CustomerId, CustomerDescription > from Invoice_Table join customer_table on > invoice_table.customerId = > customer_table.customerId > group by customerId, customerDescription > > You can always build more complex statements, use UNIONs > to get control > breaks etc... > > Just my 2 cents. >
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.