Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C2EA16500BD for ; Mon, 14 Jul 2008 03:37:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 21516-08 for ; Mon, 14 Jul 2008 03:37:44 -0300 (ADT) X-Greylist: delayed 00:06:42.885173 by SQLgrey-1.7.6 Received: from renaissance-it.com (unknown [164.164.87.55]) by postgresql.org (Postfix) with ESMTP id 4CD9765007C for ; Mon, 14 Jul 2008 03:37:43 -0300 (ADT) Received: (qmail 15710 invoked by uid 109); 14 Jul 2008 06:30:50 -0000 Received: from 192.168.1.6 by sritmail (envelope-from , uid 112) with qmail-scanner-1.25st (perlscan: 1.25st. Clear:RC:1(192.168.1.6):. Processed in 0.009888 secs); 14 Jul 2008 06:30:50 -0000 Received: from unknown (HELO praveenkm) (praveen.k@[192.168.1.6]) (envelope-sender ) by renaissance-it.com (qmail-ldap-1.03) with SMTP for ; 14 Jul 2008 06:30:50 -0000 Message-ID: <001001c8e57b$b72dcf70$274610ac@praveenkm> From: "Praveen" To: Subject: Trigger is not firing immediately Date: Mon, 14 Jul 2008 12:04:49 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000D_01C8E5A9.D0D2F8A0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/121 X-Sequence-Number: 30721 This is a multi-part message in MIME format. ------=_NextPart_000_000D_01C8E5A9.D0D2F8A0 Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable Hi All, I am having a trigger in table, If I update the the table manually = trigger is firing immediately(say 200ms per row), But if I update the = table through procedure the trigger is taking time to fire(say 7 to 10 = seconds per row). Please tell me what kind of changes can I make so that trigger fire = immediately while updating the table through procedure ? Regards, Praveen ------=_NextPart_000_000D_01C8E5A9.D0D2F8A0 Content-Type: text/html; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable

Hi All,

I am having a = trigger in table,=20 If I update the the table manually trigger is firing = immediately(say 200ms=20 per row), But if I update the table through procedure the trigger = is taking=20 time to fire(say 7 to 10 seconds per row).

Please tell me what kind of = changes can I=20 make so that trigger fire immediately while updating = the table=20 through procedure ?

Regards,

Praveen

------=_NextPart_000_000D_01C8E5A9.D0D2F8A0--