Re^4: Help on selecting and deleting many records in a DB.

I seems rather more complicated, not easier. In what way does this make the queries faster? Benchmark?

Comment on Re^4: Help on selecting and deleting many records in a DB.

Replies are listed 'Best First'.
Re^5: Help on selecting and deleting many records in a DB. by Anonymous Monk on Apr 06, 2014 at 08:39 UTC
I would try something like: `my %ipH; my $sth = spi_query("SELECT * FROM data"); while (defined ($row = spi_fetchrow($sth))) { delete fetched or hashed; }` [download] but it's not tested.	[reply] [d/l]
Re^5: Help on selecting and deleting many records in a DB. by Anonymous Monk on Apr 06, 2014 at 09:28 UTC
And deletion is done by a command like: `$req = spi_exec_query("DELETE FROM data WHERE id = $id",1);` [download]	[reply] [d/l]
Re^5: Help on selecting and deleting many records in a DB. by Anonymous Monk on Apr 06, 2014 at 07:34 UTC
A cavall donat, no li miris el dentat.	[reply]