Re: sql in php with paging

[Thorbjørn Ravn Andersen <ravn@xxxxxxxxxx>]

Nathan Andelin skrev:
> > From: Thorbjørn Ravn Andersen
> > Unfortunately this  doesn't scale well.  You need to be able to serve 
> > more users than you have database connections.
> >     
>
>
> I understand that if persistent connections are maintained for each user, that may lead to many database connections, but what resource constraint do you see?
>   
In my experience database connections are heavy weight objects and 
should be kept to a minimum.  I do not know the maximum number of 
concurrent AS/400 database connections, but it might be an interesting 
number to work out.

My point is that the practical number of users which the Java part can 
handle may be much higher than the practical number of concurrent 
connections the database can handle.  Hence you hit a wall faster.

/Thorbjørn