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

Thanks for your reply Holger,

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

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.

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.

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).

Gregor.

"Holger Baer" <holger.baer_at_science-computing.de> wrote in message news:3E660402.7070703_at_science-computing.de...
> Gregor wrote:
> > Hello all,
> >
> > I am a software developer, with some knowledge about databases, but I
would
> > like to know how experts look at this problem.
> >
>
> I don't feel like an expert but you can't have it all ;-)
>
> > I am developing a Management Information System for a customer. This
> > customer has 2 DBA's how disagree with me. This is the situation:
> >
> [..]
>
> >
> > There are 5 directors and 5 local managers. When one of these users asks
for
> > information, the query returns approximately 500.000 record (sorted
> > alphabetical!). The queries for the shop managers only return
approximately
> > 10.000 record (sorted alphabetical).
>
> And what the hell will they do with all those records? Read them line by
> line?
>
> >
> > Shop managers use the system daily and others use it weekly.
>
> So directors and local managers are the ones that can read really fast?
> They have to take 50 times the amount of information compared to the
> shop managers, but they only have 5 times the time for it (assuming a
> 5 days week).
> >
> > The DBA's of my customer say that this system is never going to work,
> > because it is too much for the database server.
>
> They're wrong, it's not going to be used by the users, so no worries
> about the server!
>
> >
> > I think that with the right hardware and the right configuration of the
> > oracle database it should work.
>
> No, it will never work, because your users don't get what they really
> need, but as much as you manage to throw at them.
>
> Search google for 'oracle'. It tells me that there are about 7,510,000
> hits ( in approximately 0.05 seconds). Go and read them and come back
> when you're done...
>
> No seriously, give your users what they really need for their current
> work and you'll be surprised that they will typically only want to have
> some number between 10 and 100 records on their screen - and this will
> be the amount of information you need to get from the database.
>
> Holger
>
Received on Wed Mar 05 2003 - 09:09:08 CST