maria-discuss team mailing list archive

[Rhys Campbell <Rhys.Campbell@xxxxxxxxxxxxxxxxx>]

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 & DELETED (in effect similar to the OLD / NEW tags) and the trigger executes only once...

https://msdn.microsoft.com/en-us/library/ms191300.aspx 


Cheers,

Rhys

-----Original Message-----
From: Maria-discuss [mailto:maria-discuss-bounces+rhys.campbell=tradingscreen.com@xxxxxxxxxxxxxxxxxxx] On Behalf Of Federico Razzoli
Sent: 12 June 2015 04:02
To: Geoff Montee; Roberto Spadim
Cc: MariaDB discuss
Subject: Re: [Maria-discuss] DELETE FROM RETURNING

In the meanwhile, we can use ON DELETE triggers. But the request is a good idea, because it is a common operation when we want to move some rows to history tables.

Federico


--------------------------------------------
Gio 11/6/15, Roberto Spadim <roberto@xxxxxxxxxxxxx> ha scritto:

 Oggetto: Re: [Maria-discuss] DELETE FROM RETURNING
 A: "Geoff Montee" <geoff.montee@xxxxxxxxx>
 Cc: "MariaDB discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
 Data: Giovedì 11 giugno 2015, 21:09
 
 +1, good idea, today
 i execute an insert, and a delete
 2015-06-11 16:07
 GMT-03:00 Geoff Montee <geoff.montee@xxxxxxxxx>:
 Hi
 Rhys,
 
 
 
 On Wed, Jun 10, 2015 at 1:23 AM, Rhys Campbell
 
 <Rhys.Campbell@xxxxxxxxxxxxxxxxx>
 wrote:
 
 > " This might be better suited as a feature request  on the MariaDB JIRA."
 
 >
 
 > I got chastised for doing that before so I'm trying  to play nice! ;-)
 
 >
 
 
 
 I don't know why you were chastised in the past,  but I've added this
 
 to the JIRA:
 
 
 
 https://mariadb.atlassian.net/browse/MDEV-8307
 
 
 
 It sure sounds like a useful feature to me. Thanks for the  suggestion!
 
 
 
 Geoff
 
 
 
 _______________________________________________
 
 Mailing list: https://launchpad.net/~maria-discuss
 
 Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
 
 Unsubscribe : https://launchpad.net/~maria-discuss
 
 More help   : https://help.launchpad.net/ListHelp
 
 
 
 
 --
 Roberto Spadim
 SPAEmpresarial - Software ERPEng. Automação e  Controle
 
 -----Segue allegato-----
 
 _______________________________________________
 Mailing list: https://launchpad.net/~maria-discuss
 Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx  Unsubscribe : https://launchpad.net/~maria-discuss
 More help   : https://help.launchpad.net/ListHelp
 

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp