Subject | Re: [firebird-support] Re: IS this the right thing to do (trigger) |
---|---|
Author | Alexandre Benson Smith |
Post date | 2008-11-20T23:54:40Z |
Robert martin wrote:
"isolation level" :)
I think reports or other long running "analytical" (don't find a better
word for it) queries are very good candidates for snapshot transactions.
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
> I assume this is safe only if run in a snapshot (forget the phrase)According to some people anything besides snapshot is just not
> transaction, otherwise entries added while the SP is running might get
> deleted but not summed?
>
> Will look at implementation !
>
> Love the solution
> Rob
>
"isolation level" :)
I think reports or other long running "analytical" (don't find a better
word for it) queries are very good candidates for snapshot transactions.
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br