Re: Feedback on approach requested

Thanks Rob, your feedback is appreciated


On Tue, 11 Oct 2005 13:55:16 -0500, rob wrote
> Suppose you had to query this file that had 2 million records.  In 
> it is a load number and a date, perhaps state, etc.  And every time 
> you added/updated/deleted a record in this database, it would 
> automatically update another file that was summarized.  Perhaps only 
> three fields: Date, number of loads, state.  Or some such 
> combination.  You could add a trigger to the 2mil record file that 
> would automatically update this summary file.  That way you would 
> not have to modify one line of any of the program(s) that update the 
> big file.
> 
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> "Douglas W. Palme" <dpalme@xxxxxxxxxxx> 
> Sent by: web400-bounces@xxxxxxxxxxxx
> 10/11/2005 01:38 PM
> Please respond to
> Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
> 
> To
> Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
> cc
> 
> Fax to
> 
> Subject
> Re: [WEB400] Feedback on approach requested
> 
> I am running a bit slow on the uptake today Rob, I have no clue what 
> you meant LOL
> 
> On Tue, 11 Oct 2005 13:26:16 -0500, rob wrote
> > As Roy Rogers horse comes galloping up to the rescue - "Here Trigger"...
> > 
> > Rob Berendt
> > -- 
> > Group Dekko Services, LLC
> > Dept 01.073
> > PO Box 2000
> > Dock 108
> > 6928N 400E
> > Kendallville, IN 46755
> > http://www.dekko.com
> > 
> > "Douglas W. Palme" <dpalme@xxxxxxxxxxx> 
> > Sent by: web400-bounces@xxxxxxxxxxxx
> > 10/11/2005 01:03 PM
> > Please respond to
> > Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
> > 
> > To
> > "Web400 List" <web400@xxxxxxxxxxxx>
> > cc
> > 
> > Fax to
> > 
> > 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.
> > 
> > -- 
> > 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.
> 
> 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.
> 
> -- 
> 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.


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