Re: sql in php with paging

Nathan Andelin skrev:

From: Thorbjørn Ravn Andersen
When you get this up and running the JPQL (sql look alike) is
extremely powerful ...

Are you suggesting JPQL for a php application?

No. I was commenting on the Java programmers comment.

I understand that the "P" in JPQL stands for Persistence, but is it based on persistent connections for each user? Where SQL result sets retain their state from one request to the next? No need to evoke additional "select" statements? Just fetch next or prior sets of rows

The persistence is about mapping java objects to database table rows, which is a typical pain point and performance bottleneck.

My Java colleages ended up writing a DB connection manager which managed references to all persistent connections for all users. If a connection were unused for a period of time, it would expire, and get released. I assume one could write something similar in php.

Unfortunately this doesn't scale well. You need to be able to serve more users than you have database connections.


/Thorbjørn