in reply to Perl DBI (sybase) rapidly delete large number of records
One solution is to extract the data from the database, and feed the data back in, one by one, with a delete command.
The other solution is to use the nature of a database correctly, operating on sets of data, and keeping the operation with the database, which is optimized to handle such situations.
Why does the correct solution strike you as being a hack?
--
TTTATCGGTCGTTATATAGATGTTTGCA
|
|---|