On Wed, Apr 26, 2017 at 5:34 PM, Kim Gräsman <kim.gras...@gmail.com> wrote:
> Den 26 apr. 2017 3:45 em skrev "Richard Hipp" <d...@sqlite.org>: > > > On 4/26/17, Richard Hipp <d...@sqlite.org> wrote: > > > That would imply you are changing about 5 million pages. > > 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. > Which such a small page size though? What's the native filesystem page size in your situation? I suspect having a single row per page (or worse, fewer than 1 per page) is not ideal perf-wise, no? --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users