Subj : Re: CPU overload? To : Ellen K. From : Robert Comer Date : Tue Feb 13 2001 05:33 pm From: "Robert Comer" > The very first query I ran using it was against 5 tables, the largest > of which has ~45 million rows... it took 7 minutes and returned > ~117,000 rows. I thought that was very acceptable performance. That does sound reasonable, but it depends on complexity. > Are you fronting DB2 with it? Or you guys have an actual data > warehouse? We have an Oracle based datawarehouse. It's in addition to our normal AS/400 DB2 stuff. It's something division makes us do for reporting -- never really used locally. I've used it to query DB2, but most of the time it's more complicated and timely doing it in BO than to do it another way. - Bob Comer "Ellen K." <72322.1016@compuserve.com> wrote in message news:cd7k8tk3g1k1b0pip0dq9r37lm71oj1mdf@4ax.com... --- BBBS/NT v4.00 MP * Origin: telnet://HarborWebs.com http://HarborWebs.com:8081 (1:379/45) .