Hi, I'm doing some large cross-table deletes in MySQL, and I was wondering if anybody could comment on best practise for large deletes in MySQL, this is what I'm doing. Firstly as there's no subqueries (don't want to upgrade to 4.1 yet) I'm constructing a temporary table to manipulate. >From this I can work out what needs to be deleted and where it needs to be deleted. Regarding these deletes (they could be 10,000 records + (could scale to a very large amount)) should I use DELETE FROM blah WHERE ID = blah OR ID = ........ or should I be more radical and use Truncate table blah, then insert the data I want to keep.
Thanks, Rafe Fitzpatrick Senior Developer http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
