Just throw the list in another table

1,095 registered users | 1 active user | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #171,659 by ChrisR 8/30/04 10:39:32 AM Reply	Just throw the list in another table And either do an IN clause or a direct join: \n DELETE MyTable\n FROM\n MyTable myt,\n DelTable dlt\n WHERE (myt.key = dlt.key)\n
Post #171,660 by bluke 8/30/04 10:41:15 AM Reply	But won't I just be spending the time ... inserting the elements into the other table. This is a one time event.
Post #171,663 by ChrisR 8/30/04 10:55:15 AM Reply	If it's a one time event... ...i don't think it matters which way you do it. IN clauses are fairly efficient if the column is indexed. Must admit that I've never heard of the 500 limit on the items. Just tried an IN clause with 1028 entries and it worked fine. Think your DBA is thinking of 6.5 days.

Bulk delete - (bluke) - (6) - Aug. 30, 2004, 02:21:16 AM EDT

Partition the DELETE. - (static) - (2) - Aug. 30, 2004, 03:16:35 AM EDT

MySQL != MS-SQL - (altmann) - (1) - Aug. 30, 2004, 04:10:28 AM EDT

D'oh. Missed that. Sorry. -NT - (static) - Aug. 30, 2004, 09:53:08 PM EDT

Just throw the list in another table - (ChrisR) - (2) - Aug. 30, 2004, 10:39:32 AM EDT

But won't I just be spending the time ... - (bluke) - (1) - Aug. 30, 2004, 10:41:15 AM EDT

If it's a one time event... - (ChrisR) - Aug. 30, 2004, 10:55:15 AM EDT

Yay! You got a... thing.
37 ms