Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9C1C065062B for ; Mon, 14 Jul 2008 02:53:18 -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 83234-07 for ; Mon, 14 Jul 2008 02:53:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from renaissance-it.com (unknown [164.164.87.55]) by postgresql.org (Postfix) with ESMTP id A58F165062A for ; Mon, 14 Jul 2008 02:53:13 -0300 (ADT) Received: (qmail 17817 invoked by uid 109); 14 Jul 2008 05:53:02 -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.010006 secs); 14 Jul 2008 05:53:02 -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 ; 14 Jul 2008 05:53:02 -0000 Message-ID: <011701c8e576$c4bcfa80$324610ac@ramasubramanian> From: "Ramasubramanian" To: Subject: Trigger is taking time to fire Date: Mon, 14 Jul 2008 11:29:24 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0114_01C8E5A4.DE6705B0" 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.091 tagged_above=0 required=5 tests=AWL=-0.010, HTML_MESSAGE=0.001, RDNS_NONE=0.1 X-Spam-Level: X-Archive-Number: 200807/120 X-Sequence-Number: 30720 This is a multi-part message in MIME format. ------=_NextPart_000_0114_01C8E5A4.DE6705B0 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_0114_01C8E5A4.DE6705B0 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 = immediately=20 ?

Regards,

Ram

------=_NextPart_000_0114_01C8E5A4.DE6705B0--