Re: [WebSQLDatabase] Adding a vacuum() call from João Eiras on 2010-03-12 (public-webapps@w3.org from January to March 2010)

From: João Eiras <joaoe@opera.com>
Date: Fri, 12 Mar 2010 04:20:26 +0100
To: João Eiras <joaoe@opera.com>, "Dumitru Daniliuc" <dumi@chromium.org>
Cc: "Jeremy Orlow" <jorlow@google.com>, public-webapps <public-webapps@w3.org>
Message-ID: <op.u9fp8cok2q99of@coruscant>

> Looks better, and more flexible.
>
> I wonder if sqlite has a way to query the number of pages in the  
> freelist ?
> Probably something like 10% of pages in the freelist would be a good  
> threshold to allow a vacuum.
>

Oh and btw, read only transactions should disallow vacuum, I think/hope :)

Received on Friday, 12 March 2010 03:21:20 UTC