Re: I would like to know how experts look at this problem

"Gregor" <crec_at_nospam.xs4all.nl> wrote in message news:<3e66146b$0$158$e4fe514c_at_dreader8.news.xs4all.nl>...

Jeez folks, can we stop quoting the ENTIRE message thread on each reply?

>
> But you are wrong. My client has decided to use Crystal Reports with
> drill-down functionality.

Your client has *decided to use* a given product? Why didn't you have anything to say about that?

>
> Meaning that e.g.: a director gets only totals, but have to be able to 'zoom
> in' on some numbers, down to the lowest level. As crystal reports can only
> make use of one query per report, we need all the data.
>

What version of Crystal you using? I thought that restriction had been removed? You may have to use Oracle Reports instead, then.

Well, to me your message says: Crystal Reports is NOT the product to use for the volumes you want. Nothing wrong with Oracle, it can suplly the volumes you want and a LOT more. But Crystal is gonna be in so much trouble to handle 500000 rows in a query I don't even know how to explain to you how much trouble you're in for.

However with materialized views, you could potentially work around that problem. In fact given the volumes, I'd say just a group by view would too, but then we bump into Crystal's limitations!

No, your problem is Crystal. Not Oracle.

> So they want an overview, but want to be able to zoom in on the details of
> one particular "region" and maybe even the numbers of one shop.

Maybe Crystal is NOT the right product for them. Have you explained to the client that they are going to have this same problems with ANY database they pick?
Or is deranged software tool choice restricted to using it with Oracle?

> But my question was: is half a million record per transaction to much for
> oracle with 10 concurrent users (and 10.000 records per transaction for 140
> concurrent users).

Access cannot do that, nor can any other database from M$.

500000*10 = 5 million rows. How often is this gonna be done? 140*10000 = 14 million rows. How often is this gonna be done?

Do you know of ANY database system that can deliver those numbers, consecutively, in a small Windows NT server? Me neither. Although I'm quite sure you'll hear from M$ that SQL Server can do it. As usual.

I'd listen to your dbas if I were you. They might know a little bit more about system capacity planning than you do.

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au Received on Wed Mar 05 2003 - 18:54:10 CST