Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

trigger accumulates work ares per db-connection

2 posts in Trigger Last posting was on 2008-03-11 15:35:16.0Z
Robert Heuvel Posted on 2008-03-07 15:28:01.0Z
From: "Robert Heuvel" <robert.heuvel@isopass.com>
Newsgroups: advantage.trigger
Subject: trigger accumulates work ares per db-connection
Date: Fri, 7 Mar 2008 16:28:01 +0100
Lines: 10
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545
NNTP-Posting-Host: 91.6.170.40
Message-ID: <47d15db7@solutions.advantagedatabase.com>
X-Trace: 7 Mar 2008 08:22:31 -0700, 91.6.170.40
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!91.6.170.40
Xref: solutions.advantagedatabase.com Advantage.Trigger:368
Article PK: 1136428

I have a very simple aep/delphi-trigger that just executes an "update table
set field = field+1". It accumulates 75 work areas per connection even
though the invoking TAdsTable.Insert-Table is closed after each and every
Insert and the TAdsQuery used in the aep-trigger is closed and
AdsCloseStatement is called too. TAdsQuery component gets freed at the end
of the trigger call as well .

How can I stuff the hole without closing the database connection every time
(runs via internet , closing, opening VERY slow).


Robert Heuvel Posted on 2008-03-11 15:35:16.0Z
From: "Robert Heuvel" <robert.heuvel@isopass.com>
Newsgroups: advantage.trigger
References: <47d15db7@solutions.advantagedatabase.com>
In-Reply-To: <47d15db7@solutions.advantagedatabase.com>
Subject: Re: trigger accumulates work ares per db-connection
Date: Tue, 11 Mar 2008 16:35:16 +0100
Lines: 16
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545
NNTP-Posting-Host: 91.6.170.135
Message-ID: <47d6a56c@solutions.advantagedatabase.com>
X-Trace: 11 Mar 2008 09:29:48 -0700, 91.6.170.135
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!91.6.170.135
Xref: solutions.advantagedatabase.com Advantage.Trigger:377
Article PK: 1136438

no transactions used,
triggers use implicit transaction

"Robert Heuvel" <robert.heuvel@isopass.com> schrieb im Newsbeitrag
news:47d15db7@solutions.advantagedatabase.com...

>I have a very simple aep/delphi-trigger that just executes an "update table
>set field = field+1". It accumulates 75 work areas per connection even
>though the invoking TAdsTable.Insert-Table is closed after each and every
>Insert and the TAdsQuery used in the aep-trigger is closed and
>AdsCloseStatement is called too. TAdsQuery component gets freed at the end
>of the trigger call as well .
>
> How can I stuff the hole without closing the database connection every
> time (runs via internet , closing, opening VERY slow).
>