On Fri, Jul 23, 2010 at 5:11 AM, Taras Glek wrote:
> Hello,
> Recently I spent some time investigating sqlite IO patterns in Mozilla.
> Two issues came up: keeping sqlite files from getting fragmented and
> fixing fragmented sqlite files.
>
>
Funny, that's why I like reading someone's questions
On 07/23/2010 04:38 AM, Martin Engelschalk wrote:
>Hello Taras, List,
>
> I have been fighting the same problems described here for a long time,
> and have no real elegant solution. So, the proposed solution of the OP
> below would be ideal for me too.
> The proposed pragma could also define a
On 23 Jul 2010, at 2:11am, Taras Glek wrote:
> Recently I spent some time investigating sqlite IO patterns in Mozilla.
> Two issues came up: keeping sqlite files from getting fragmented and
> fixing fragmented sqlite files.
If I understand correctly, there are two levels of fragmentation invol
Hello Taras, List,
I have been fighting the same problems described here for a long time,
and have no real elegant solution. So, the proposed solution of the OP
below would be ideal for me too.
The proposed pragma could also define a number of pages to be allocated
at once instead of a number
Hello,
Recently I spent some time investigating sqlite IO patterns in Mozilla.
Two issues came up: keeping sqlite files from getting fragmented and
fixing fragmented sqlite files.
First on fixing fragmentation:
Currently we write pretty heavily to our databases. This causes the
databases to g
5 matches
Mail list logo