Richard
If you mean by transactional triggers, triggers fires once per operation
then yes
Richard Vowles wrote:
Do you mean transactional triggers or the concept of "batch starting
now, batch ending now"?
---
Richard Vowles, Solutions Architect, Borland New Zealand
email: [EMAIL PROTECTED]
phone: +64-9-9184573
cell: +64-21-467747
other: MSN [EMAIL PROTECTED], skype: rvowles
blog: http://www.usergroup.org.nz/blogs/selectBlog.html?id=39769
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Neven MacEwan
Sent: Thursday, 1 June 2006 2:57 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] Why InterBase
Paul
I didn't say it was efficient :-) Though some could argue that there is
a lot you can do that don't require triggers for ie constraints.
I'd more likely accept the point that mssql does not have row level
triggers, this makes cascading key updates require a cursor in the
trigger yuk!. AFAIK IB doesn't have batch triggers so one could argue
that row level triggers are a lot less efficient in terms of CPU and
memory load than batch ones :-)
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
--
Neven MacEwan (B.E. E&E)
Ph. 09 620 1356 Mob. 027 4749 062
New Address Details
===================
MWK Computer Systems
1 Taumata Rd
Sandringham
Auckland
Ph 620 1356
Fx 620 1336
begin:vcard
fn:Neven MacEwan
n:MacEwan;Neven
email;internet:[EMAIL PROTECTED]
tel;work:649 620 1356
tel;fax:649 620 1336
tel;cell:0274 749 062
version:2.1
end:vcard
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
