Re: SQL trigger question

[Alan Campin <alan0307d@xxxxxxxxx>]

As far as I know you can't. Think about what we would happen if you did.
Tread 2 might complete before tread1 but tread 2 might have dependancies on
tread1 working. I doubt it would be supported.

Is that why you are using three triggers trying to make it perform faster?
Having three triggers is going to add overhead. Why not put in one trigger?
If you are looking to improve performance on writes, use any array. Map a
user space or memory. Write all the records into the array and do one write.
.

On Wed, Aug 25, 2010 at 3:20 PM, <Yan.Zhang@xxxxxxxxxx> wrote:

> If I want to get separate threads going -- all these threads run parallel.
> How do I do it?
>
>
> YanZ
>
>
>
>
> From:
> "Clapham, Paul" <pclapham@xxxxxxxxxxxxx>
> To:
> "Java Programming on and around the IBM i" <java400-l@xxxxxxxxxxxx>
> Date:
> 08/25/2010 05:16 PM
> Subject:
> RE: SQL trigger question
> Sent by:
> java400-l-bounces@xxxxxxxxxxxx
>
>
>
> That seems perfectly normal to me. In fact I would be surprised if the
> database software started separate threads for each of the triggers.
> That would be just asking for trouble.
>
> PC2
>
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of
> Yan.Zhang@xxxxxxxxxx
> Sent: August 25, 2010 13:58
> To: Java Programming on and around the iSeries / AS400
> Subject: SQL trigger question
>
> I have 3 "after update" triggers on Table0: T1, T2, and T3. All these 3
> triggers are built on Table0.
> T1 inserts some records into Table1;
> T2 inserts some records into Table2;
> T3 inserts some records into Table3.
>
> So, after Table0 is updated, I think T1,T2.and T3 would be launched at
> the same time.
> But why in my experiments it shows the "insert into...." for 3 tables
> are executed sequentially? i.e. A bunch of records are inserted into
> Table1, then  a bunch of records are inserted into Table2, then  a bunch
> of records are inserted into Table3.
>
>
> thanks,
> YanZ
> --
> This is the Java Programming on and around the IBM i (JAVA400-L) mailing
> list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at http://archive.midrange.com/java400-l.
>
> --
> This is the Java Programming on and around the IBM i (JAVA400-L) mailing
> list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>
>
> --
> This is the Java Programming on and around the IBM i (JAVA400-L) mailing
> list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.