RE: Feedback on approach requested

Douglas,

Consider the following: the same index that will allow you to get good
performance from you detail query would provide all the information
needed to determine if a particular state has any loads in it or not.

Thus, I doubt that having a separate summary file will gain you much in
terms of performance. 


Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Douglas W. Palme
Sent: Tuesday, October 11, 2005 2:03 PM
To: Web400 List
Subject: [WEB400] Feedback on approach requested

I would like some feedback from the list regarding a project we are
going to start working on.

We want to list our available loads on our website in an image map, so
that when the user hovers their cursor over a particular state it will
reflect the number of loads we have available and if they click on the
state it will provide them with a listing of the load information.

This by itself should be easy enough to accomplish with Bob Cozzi's
tool, my question is more along the lines of extracting the specific
number of loads.

One way which I am not thrilled about would be to query it with SQLRPGLE
and put out the data.  We could also maintain a separate PF that
contains the name for each state and a numeric value with the number of
loads available.

Obviously to display the actual load information will require an sql
call, which is fine for that aspect, but getting the initial page to
load would be much faster if it was to read a simple PF that could be
updated when a load is booked (+1) or (-1) when a load has been
assigned.

Any thoughts, suggestions on the approach would be appreciated.


If you bought it, it was hauled by a truck - somewhere, sometime.

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.