Re: oracle limitations

Hi,
I can't give you any numbers but I think that: first you fixe yourself the number of concurrent users then you set this limit in your webdb ou whatever and a as a goal to get.

The problem is that:
Do you have complex queries or very simple ? In the first case, pay attention
to write performant queries.

Are there concurrent updates or simple consultations ? In the first case,
pay attention to locking situations ==> slow down your response time.

Otherwise, one of the most important factor is the answer response of your hard disks (think about disk repartionning).

Cheers.

kevin moriarty wrote:
>
> how many concurrant users can I have for the following system:
> document tracking
> 150 tables
> 300 new records a day
> 5 gig growth/year
> table level business logic
> 256 meg ram
> PIII 500
> using 8i and webdb
> ?
> what other factors are there to consider?
Received on Mon Dec 20 1999 - 09:45:36 CST