Persistent Sessions in DB connection for QZDASOINIT, implemented by Nathan

[<elehti@xxxxxxxxxxxxxxxxxx>]

Nathan Andelin,
I am VERY interested in hearing more about Persistent Sessions in DB
connection for QZDASOINIT, (shown below).

Can you please explain how your team achieved Persistent Sessions in DB
connection for QZDASOINIT.
That is incredible.

Eric Lehti, (918) 879-6036 direct;   (918) 292-9142 mobile
Ameristar Fence Products  


From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Nathan Andelin
Sent: Tuesday, October 21, 2008 9:26 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] sql in php with paging

> When a few of my Java colleagues were trying to implement paging, I
suggested that each user >session be given their own DB connection and
allow the QZDASOINIT servers to maintain state for each, rather than
running a new Select for each page.  They rejected that idea initially,
over concerns of scalability, but after several attempts with other
designs, they came back and implemented it the way I originally
suggested.

Nathan