Hello Richard !
On 02/10/16 18:02, Richard Hipp wrote:
For your specific UPDATE, it seems like SQLite ought to be able to do
it all in one pass, and thus avoid using all that memory to store the
rowids. This looks like an opportunity to improve the query planner.
That would be nice, also I noticed that sqlite seem to do a delete then
an insert for updates even when it would be possible to update in place,
with tables with several fields and indices seems to be a waste of work.
Cheers !
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
