Domingo Alvarez Duarte wrote: > I'm still fighting to use sqlite with a 20GB database and now I'm > trying to update a table with 980M rows but sqlite is eating all my > memory (2GB) and making blocking my computer (too much swap).
IIRC SQLite keeps a list of (the IDs of) all rows to be updated. Try making the updates in smaller chunks (WHERE ... BETWEEN ...). Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
