[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