Re: sql in php with paging -- WEB400

Subject: Re: sql in php with paging
From: Nathan Andelin <nandelin@xxxxxxxxx>
Date: Tue, 21 Oct 2008 09:46:02 -0700 (PDT)
List-archive: <http://archive.midrange.com/web400>
List-help: <mailto:web400-request@midrange.com?subject=help>
List-id: Web Enabling the AS400 / iSeries <web400.midrange.com>
List-post: <mailto:web400@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/web400>, <mailto:web400-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/web400>, <mailto:web400-request@midrange.com?subject=unsubscribe>

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?

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?

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.

Nathan.

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: sql in php with paging , Thorbjørn Ravn Andersen

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.