Re: Slow script: DBI, MySQL, or just too much data?

You might try this it will do your delete in one step.

$sth = $dbh->prepare(
        "delete from testDBRepCats where repCatID IN ("
        .  join(', ', map({'?'} @$repCats)) .  ")");
$done = $sth->execute(@$repCats);
[download]

But it sounds to me like a database problem. Are you using transactions. If so try turning off ATUO_COMMIT and do one commit at the end. Also you should look at the indexes you have. Having too few (or too many) indexes can slow things down.

It is hard to say more without seeing the schema.

-- gam3
A picture is worth a thousand words, but takes 200K.

Comment on Re: Slow script: DBI, MySQL, or just too much data? Download Code

Replies are listed 'Best First'.
Re^2: Slow script: DBI, MySQL, or just too much data? by menolly (Hermit) on Apr 15, 2005 at 18:01 UTC
It's MySQL 4.0.22. No transactions.	[reply]