Roland, Andrew Those are good reasons. Thanks.
henrik On Sun, Sep 11, 2011 at 9:32 PM, Andrew Hutchings <[email protected]> wrote: > Hi Olaf, > > On 11/09/11 16:30, Olaf van der Spek wrote: >> >> On Sat, Sep 10, 2011 at 10:51 PM, Andrew Hutchings >> <[email protected]> wrote: >>> >>> This was discussed a long time ago. I believe Brian had a plan but I'm >>> not >>> sure what it was. We have to think carefully about behaviour such as >>> this >>> though since some application may do this so that it can be part of a >>> transaction. >> >> How does that affect this issue? > > In the case of DELETE from t1; I would hope it is obvious. As part of a > transaction you may need to delete all rows of a small table. If this fails > you will need to rollback. You will also want this committed with the rest > of your data changes rather than separately. TRUNCATE is not part of a > transaction so this cannot be done. > > In fact in the small table case TRUNCATE will be slower than DELETE anyway. > > Kind Regards > -- > Andrew Hutchings - LinuxJedi - http://www.linuxjedi.co.uk/ > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > -- [email protected] +358-40-8211286 skype: henrik.ingo irc: hingo www.openlife.cc My LinkedIn profile: http://www.linkedin.com/profile/view?id=9522559 _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
