Den 26 apr. 2017 3:45 em skrev "Richard Hipp" <[email protected]>:
> On 4/26/17, Richard Hipp <[email protected]> wrote: > > That would imply you are changing about a > > half million pages of your database inside a single transaction. > > Correction: About 5 million pages. Missed a zero. (Time for coffee, I > guess) > Always time for coffee. Great, that means the numbers add up. This is a monster transaction updating 5M rows, and page size is 512 bytes, so I think we have roughly 1 row/page. I never got the sense that the shm size was directly proportional to number of pages modified, but I can see that now. Thanks, - Kim _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
