Delete whole table in one go versus batches

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 20 Aug 2002 11:19:23 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70287F245@lnewton.leeds.lfs.co.uk>

That's just being nasty Niall :o)
But I like it !

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Niall Litchfield [mailto:n-litchfield_at_audit-commission.gov.uk] Posted At: Tuesday, August 20, 2002 11:01 AM Posted To: server
Conversation: Delete whole table in one go versus batches Subject: Re: Delete whole table in one go versus batches

Though it won't work in Ender's case you forgot the more general advice to
issue LOCK TABLE ... EXCLUSIVE at the start of the transaction just in case
:-( - not to mention the need to set the process running and go off to a meeting where you are uncontactable before you get to the commit/rollback
stage. Received on Tue Aug 20 2002 - 05:19:23 CDT