Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4EFB7650727 for ; Fri, 11 Jul 2008 04:36:41 -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 91644-06 for ; Fri, 11 Jul 2008 04:36:29 -0300 (ADT) X-Greylist: delayed 00:06:44.880109 by SQLgrey-1.7.6 Received: from renaissance-it.com (unknown [164.164.87.55]) by postgresql.org (Postfix) with ESMTP id 9629C650710 for ; Fri, 11 Jul 2008 04:36:24 -0300 (ADT) Received: (qmail 1396 invoked by uid 109); 11 Jul 2008 07:29:37 -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.009627 secs); 11 Jul 2008 07:29:37 -0000 Received: from unknown (HELO ramasubramanian) (ramasubramanian.g@[192.168.1.6]) (envelope-sender ) by renaissance-it.com (qmail-ldap-1.03) with SMTP for ; 11 Jul 2008 07:29:37 -0000 Message-ID: <009e01c8e328$bc6d3610$324610ac@ramasubramanian> From: "Ramasubramanian" To: Subject: Trigger is taking time to fire Date: Fri, 11 Jul 2008 13:05:47 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_009B_01C8E356.D5E052C0" 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-Spam-Status: No, hits=0.088 tagged_above=0 required=5 tests=AWL=-0.013, HTML_MESSAGE=0.001, RDNS_NONE=0.1 X-Spam-Level: X-Archive-Number: 200807/95 X-Sequence-Number: 30695 This is a multi-part message in MIME format. ------=_NextPart_000_009B_01C8E356.D5E052C0 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 = it is not taking time(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). How can i make the trigger to fire immediately? Regards, Ram ------=_NextPart_000_009B_01C8E356.D5E052C0 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 it is not taking time(say 200ms per = row), But=20 if i update the table through procedure the trigger is taking time to = fire(say 7=20 to 10 seconds per row).

How can i make the trigger to fire=20 immediately?

Regards,

Ram

------=_NextPart_000_009B_01C8E356.D5E052C0--