Re: WEB400 Digest, Vol 3, Issue 239

[SASchollenberger@xxxxxxxxxxxx]

Doug --

> 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.

You could create an SQL VIEW over your "load detail" table that grouped by
state and included
a count(*) column.  Then building an SQL INDEX over the state column of the
"load detail" would
make accessing the view very quick since the optimizer could use that
index.

Reading the view would give you the load count to place on your web site.

----------------------
Scott

Scott A. Schollenberger
Chief Technology Officer
TENEX Systems, Inc.
2011 Renaissance Blvd., Suite 100
King of Prussia, PA  19406
Phone: 610-239-9988  Ext. 305
Fax: 610-239-9995
E-mail: saschollenberger@xxxxxxxxxxxx
Web: www.tenexsys.com

IBM Certified Specialist - eServer i5 iSeries Technical Solutions
Implementer V5R3

CONFIDENTIALITY NOTICE:  This email message, including any attachments, is
for the sole use of the intended recipient(s) and contains confidential and
privileged information.  Any unauthorized review, use, disclosure or
distribution is prohibited.  If you are not the intended recipient, please
contact the sender by reply email and destroy all copies of the original
message.

----------------------
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."    --Benjamin Franklin
----------------------