in reply to Perl DBI (sybase) rapidly delete large number of records

Sounds to me like you just need a transaction wrapped around the whole thing. 
BEGIN
DELETE FROM y WHERE x=1;
DELETE FROM y WHERE x=2;
DELETE FROM y WHERE x=3;
...
COMMIT

[download]
That'll make things way faster.

Replies are listed 'Best First'.
Re^2: Perl DBI (sybase) rapidly delete large number of records
by mpeppler (Vicar) on May 11, 2007 at 06:23 UTC
    Don't assume that what make things faster with one database engine will make it faster with another.

    In the case of Sybase ASE this probably won't make that much difference, but will potentially cause much locking, and may exceed the size of the transaction log.

    Michael

[reply]

In Section Seekers of Perl Wisdom