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.

Triggers on ASE 12.0 with Web application?

2 posts in Internet Last posting was on 2001-05-04 13:23:52.0Z
David Miller Posted on 2000-04-28 21:02:56.0Z
Reply-To: "David Miller" <dmill@bellsouth.net>
From: "David Miller" <dmill@bellsouth.net>
Subject: Triggers on ASE 12.0 with Web application?
Date: Fri, 28 Apr 2000 17:02:56 -0400
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4029.2901
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4029.2901
Message-ID: <zvu9nYVs$GA.185@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.internet
NNTP-Posting-Host: 63.73.211.202
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.internet:346
Article PK: 1067403

Anyone,

I am looking for a document or some help to explain the pros and cons of
using triggers in a db that is for a Web based application that has a large
volume of activity.

If I start using an insert trigger on my vist streaming table will I be in
real trouble. I want hard numbers if possible.

Thanks,
Miller
dmill@bellsouth.net


Ray DiMarcello Posted on 2001-05-04 13:23:52.0Z
From: "Ray DiMarcello" <rdimarcello@ingva.com>
References: <zvu9nYVs$GA.185@forums.sybase.com>
Subject: Re: Triggers on ASE 12.0 with Web application?
Date: Fri, 4 May 2001 09:23:52 -0400
Lines: 27
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <98mU3BK1AHA.254@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.internet
NNTP-Posting-Host: 207.245.124.67
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.internet:228
Article PK: 1067285

Well hard numbers are difficult to give you since I don't know your app.
However, you seem to be saying, "if I add a trigger to a table that gets
inserted to when my web site gets hit, will I have a problem?" That
depends. What's the trigger gonna do? Is there contention now for the
inserts on the visit streaming table?

RD

David Miller wrote in message ...
>Anyone,
>
>I am looking for a document or some help to explain the pros and cons of
>using triggers in a db that is for a Web based application that has a large
>volume of activity.
>
>If I start using an insert trigger on my vist streaming table will I be in
>real trouble. I want hard numbers if possible.
>
>Thanks,
>Miller
>dmill@bellsouth.net
>
>
>