[DUG] Why InterBase

Neven MacEwan neven at mwk.co.nz
Thu Jun 1 15:26:07 NZST 2006


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: richard.vowles at borland.com
> phone: +64-9-9184573
> cell: +64-21-467747
> other: MSN richard.vowles at borland.com, skype: rvowles
> blog: http://www.usergroup.org.nz/blogs/selectBlog.html?id=39769
> 
> -----Original Message-----
> From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz]
> 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
> Delphi at ns3.123.co.nz
> 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: neven.vcf
Type: text/x-vcard
Size: 164 bytes
Desc: not available
Url : http://ns3.123.co.nz/pipermail/delphi/attachments/20060601/45e64c2b/neven-0001.vcf


More information about the Delphi mailing list