Re: Web programming 101 question

Hey Paul,

You might get better answers from the WEB list. You will want to look into
connection pooling to reduce any overhead in establishing the ODBC
connections if you want to continue connecting to the data from outside your
System i.

We're a JDE World shop, too, so I'm familiar with the sprawl of poorly keyed
tables you're dealing with. The quality of your query and the indexes built
over the tables involved will have the greatest impact on performance in
regards to data retrieval.

In regards to a non-System i solution, we moved to PHP on the i almost a
year ago and we're very happy with the web experience that we're serving out
of it. Folks who utilize Java a lot more than I do have also expressed a
much improved experience running on the System i over connecting to it via
JDBC and ODBC.

Thanks,
Alfred

On 10/12/07, Paul Nelson <nelsonp@xxxxxxxxxxxxx> wrote:

I have managed to build a monster SQL view over a bunch of JD Edwards
files.
The purpose is to access this view via an ODBC connection being used by a
web program.

When the first request from a user comes through, the results come back in
about five minutes, but thereafter, the retrieval is very quick.
Unfortunately, this happens for each user.

My request is this: I'm looking for suggestions for a way to have some
program either in the System i or in the web server get the file to open
and
then keep it open until the end of the processing day.

For the old timers on the list, the best example I can think of is the
NEP-MRT technique used on the S/36 platform.

Thanks

Paul Nelson
Cell 708-670-6978
Office 512-392-2577
nelsonp@xxxxxxxxxxxxx


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.