Re: [Maria-discuss] ON DELETE/UPDATE/INSERT Triggers

2015-06-12 Thread Justin Swanhart
Hi, You can also use FlexCDC. It of course can capture changes from all statements via the binlog. Flexviews can also be used for "as of" queries. If you have 30 days of log data collected, you can run a query (even with inner joins) and see the results as they appeared at any time in last 30

Re: [Maria-discuss] ON DELETE/UPDATE/INSERT Triggers

2015-06-12 Thread Rhys Campbell
Yep, MSSQL does that too unless I misunderstand you. Rhys -Original Message- From: Federico Razzoli [mailto:federico_...@yahoo.it] Sent: 12 June 2015 11:37 To: Geoff Montee; Roberto Spadim; Rhys Campbell Cc: MariaDB discuss Subject: RE: [Maria-discuss] ON DELETE/UPDATE/INSERT Triggers

Re: [Maria-discuss] ON DELETE/UPDATE/INSERT Triggers

2015-06-12 Thread Federico Razzoli
Ven 12/6/15, Rhys Campbell ha scritto: Oggetto: RE: [Maria-discuss] ON DELETE/UPDATE/INSERT Triggers A: "Federico Razzoli" , "Geoff Montee" , "Roberto Spadim" Cc: "MariaDB discuss" Data: Venerdì 12 giugno 2015, 10:55 Just to add anoth

Re: [Maria-discuss] ON DELETE/UPDATE/INSERT Triggers

2015-06-12 Thread Rhys Campbell
Just to add another one into the mix (and I guess it may be related in some sense)... For ON DELETE triggers it currently fires per row. This impacts performance significantly in some situations when a lot of rows are processed. MSSQL gets around this by creating virtual tables, INSERTED & DELE