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.

Q: Performance with triggers

4 posts in Trigger Last posting was on 2005-03-16 08:15:34.0Z
Ralf Bertoldi Posted on 2005-03-07 21:54:19.0Z
From: "Ralf Bertoldi" <bertoldi@gmx.de>
Subject: Q: Performance with triggers
Newsgroups: Advantage.Trigger
User-Agent: XanaNews/1.17.2.7
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 217.249.11.190
Message-ID: <422ccd8b@solutions.advantagedatabase.com>
Date: 7 Mar 2005 14:54:19 -0700
X-Trace: 7 Mar 2005 14:54:19 -0700, 217.249.11.190
Lines: 10
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!217.249.11.190
Xref: solutions.advantagedatabase.com Advantage.Trigger:152
Article PK: 1136218

Hi,

I didn't found anything about it...

If I would have a lot of triggers... do I put them all in one dll?
Or does it make sense to put them in different dll's?
When they will be loaded? At server startup?

TIA
Ralf


Joachim Duerr (ADS Support) Posted on 2005-03-08 08:35:03.0Z
From: "Joachim Duerr (ADS Support)" <jojo.duerr@gmx.de>
Subject: Re: Q: Performance with triggers
Newsgroups: Advantage.Trigger
References: <422ccd8b@solutions.advantagedatabase.com>
Organization: Extended Systems GmbH
User-Agent: XanaNews/1.16.5.1
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 195.2.185.25
Message-ID: <422d63b7@solutions.advantagedatabase.com>
Date: 8 Mar 2005 01:35:03 -0700
X-Trace: 8 Mar 2005 01:35:03 -0700, 195.2.185.25
Lines: 16
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!195.2.185.25
Xref: solutions.advantagedatabase.com Advantage.Trigger:153
Article PK: 1136220


Ralf Bertoldi wrote in <422ccd8b@solutions.advantagedatabase.com> :

> If I would have a lot of triggers... do I put them all in one dll?
> Or does it make sense to put them in different dll's?
> When they will be loaded? At server startup?

the DLLs will be loaded at table opening - that's what I experienced
when playing around.

--
Joachim Duerr
EMEA Lead ADS Support, Extended Systems GmbH, Germany
advantage[AT]extendsys.de
Join the European Advantage Conference 2005!
Early Bird rate extended until March 15th 2005!
http://www.extendedsystems.com/go/eac2005


J.D. Mullin Posted on 2005-03-15 23:17:30.0Z
Message-ID: <886edc15a1a58c6f790eb87ee91@devzone.advantagedatabase.com>
From: J.D. Mullin <no@email.com>
Subject: Re: Q: Performance with triggers
Newsgroups: Advantage.Trigger
References: <422d63b7@solutions.advantagedatabase.com>
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Pro 521.15
NNTP-Posting-Host: 198.102.102.75
Date: 15 Mar 2005 16:17:30 -0700
X-Trace: 15 Mar 2005 16:17:30 -0700, 198.102.102.75
Lines: 17
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.75
Xref: solutions.advantagedatabase.com Advantage.Trigger:154
Article PK: 1136223

The trigger dll will be loaded the first time a user does an update that
needs to fire a trigger, not until then.

J.D. Mullin
Advantage R&D

> Ralf Bertoldi wrote in <422ccd8b@solutions.advantagedatabase.com> :
>
>> If I would have a lot of triggers... do I put them all in one dll?
>> Or does it make sense to put them in different dll's?
>> When they will be loaded? At server startup?
> the DLLs will be loaded at table opening - that's what I experienced
> when playing around.
>


Joachim Duerr (ADS Support) Posted on 2005-03-16 08:15:34.0Z
From: "Joachim Duerr (ADS Support)" <jojo.duerr@gmx.de>
Subject: Re: Q: Performance with triggers
Newsgroups: Advantage.Trigger
References: <422d63b7@solutions.advantagedatabase.com> <886edc15a1a58c6f790eb87ee91@devzone.advantagedatabase.com>
Organization: Extended Systems GmbH
User-Agent: XanaNews/1.16.5.1
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 195.2.185.25
Message-ID: <4237eb26@solutions.advantagedatabase.com>
Date: 16 Mar 2005 01:15:34 -0700
X-Trace: 16 Mar 2005 01:15:34 -0700, 195.2.185.25
Lines: 15
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!195.2.185.25
Xref: solutions.advantagedatabase.com Advantage.Trigger:155
Article PK: 1136221

J.D. Mullin wrote in
<886edc15a1a58c6f790eb87ee91@devzone.advantagedatabase.com> :

> The trigger dll will be loaded the first time a user does an update
> that needs to fire a trigger, not until then.

thanks for correction.

--
Joachim Duerr
EMEA Lead ADS Support, Extended Systems GmbH, Germany
advantage[AT]extendsys.de
Join the European Advantage Conference 2005!
Early Bird rate extended until March 15th 2005!
http://www.extendedsystems.com/go/eac2005