Re: (Mis)use of transactions

Hi,

Oops, just be sure that I'm 100% clear re: the last paragraph in my previous
post:

You DO still of course to need to use triggers. The "lie" I told had
to do with using them to manage the checkpoints. THAT functionality is much
better handled with periodic stored procedures. Triggers, however, are
still need to manage the contents of the shadow table. Specifically, you
will need "ON INSERT", "ON UPDATE", and "ON DELETE" triggers for the
Reference table.

Doug


On Fri, 10 Aug 2007 12:41:44 +0000 (UTC), Doug Morse <morse@xxxxxxxx> wrote:
...

Finally, I "lied" a bit to keep things simple, just to get the concepts
across more easily. In "real life", I wouldn't use the triggers to manage
the clearing of the checkpoints, provided your DBMS let's you schedule
certain stored procedures to run at a certain time (or, even if not, you're
...
.

Relevant Pages

  • Re: The dreaded Winmail.dat with a difference
    ... Free SQL database Firebird - full support for transaction control, triggers, stored procedures, partial SQL-99 compliance ...
    (microsoft.public.exchange.admin)
  • Re: Database notification
    ... >>No, triggers start stored procedures on the server side, but nothing ... > publish/subscribe) to the client. ... MySQL-5.0 supports triggers, and while it doesn't yet support Java ... let people write their UDFs in Java, so relatively easily you could put ...
    (comp.lang.java.databases)
  • Re: database in python ?
    ... >> defacto standard for OpenSource databases. ... Stored procedures available since 5.0 ... Triggers available since 5.0.2 ... should be no substantial speed differences between the two interfaces. ...
    (comp.lang.python)
  • RE: SP and Trigger debugging
    ... It is more feasible if you debug the stored procedures and Triggers from the ... If any way you need IDE to debug the stored Procedure VS.Net ...
    (microsoft.public.sqlserver.programming)
  • Re: Having difficulty refactoring a DB application
    ... >> I have a sensible database definition that more or less works for the ... If you have a sophisticated dbms - capable of serving 100+ users, ... Use stored procedures and triggers in the DBMS itself to encapsulate ...
    (comp.object)