Re: Code too slow for a trigger?

["John Furniss" <jfurniss@xxxxxxxxxxxxxxxxx>]

Buck,
    I'm not sure why the record is getting locked, but it is locked by the
Mapics job. So, I can't control it. I will take your advise and do a benchmark
in our test environment. Thanks for the reply.
    John

Buck Calabro wrote:

> >I've put code in a trigger program attached to our Item Master file
> >that will determine the program that called it. <snip> Would
> >this code cause the trigger to run slow, thus causing slow downs
> >for users accessing the item file?
>
> Hi John!
> The proper answer for all performance questions is 'it depends.'
>
> My advice is to run half a million records through each way and find out the
> results on your machine, with your data.  Benchmark it.
>
> On the other hand, are you forced to lock the item master record in the
> offending calling program?
>   --buck
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.

--
John Furniss
Applications Programmer
Allied Machine & Engineering Corp.
mailto:jfurniss@xxxxxxxxxxxxxxxxx
Phone (330) 343-4283 ext. 8371