If I already have a collection of row IDs of rows I wish to delete from a
table, what is a recommended/fast way to delete them from the table?
The collection is just a set/array of integers, not necessarily contiguous.
I can think of three ways:
* Prepare query containing single ID with _prepare(). Execute it with _step().
Repeat for each ID.
* Call _prepare() with a query with single parameter for the ID. _bind(),
_step(), and _reset() - repeat for each ID.
* Call _prepare() with a query containing every single one of the IDs. Then
_step() on it once. Done. Is this even possible? Since there can be a million
IDs, I'm not sure if the query can be so long.
Which way do you recommend? Are there other ways?
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
