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>...
> Thanks for your reply Holger,
>
>
>
> But you are wrong. My client has decided to use Crystal Reports with
> drill-down functionality.

Then your DBA's are correct. However, the problem isn't Oracle, it's Crystal Reports trying to use Oracle as though it were Access. There was just another thread about this, where the DBA's came up with stored procedures to precreate report data for the reporting tool. It's been too long since I've looked at CR to comment on whether or how you could drill down by going around behind CR's back. But I would guess there is some way, maybe a view generator.

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

That's his problem, he needs to drill to the 100 records from the large set dynamically using a particular wrong tool.

> >
> > Holger
> >

jg

--
@home is bogus.
My dad always used to say, anyone can fix things with the right tools,
it takes a _real mechanic_ to fix things without the right tools.  Of
course, he vowed never to get his fingernails dirty again after moving
to California.