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
