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

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 - 08:04:50 CST