On Wed, Apr 26, 2017 at 5:34 PM, Kim Gräsman <[email protected]> wrote:
> 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 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
