.
So these times are not affected by vacuum.
Thanks
Mark
> -Original Message-
> From: Brett Wilson [mailto:[EMAIL PROTECTED]
> Sent: 26 October 2005 19:22
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Very Slow delete times on larger
> databases, please
> he
Vacuuming is just slow. I don't think there is much you can do except
don't do it unless you really need it, and don't turn on autovacuum.
Brett
On 10/26/05, R S <[EMAIL PROTECTED]> wrote:
> In my case Delete happens reasonably OK but Vaccuuming takes incredibly
> long?
>
>
> On 10/21/05, Allan,
In my case Delete happens reasonably OK but Vaccuuming takes incredibly
long?
On 10/21/05, Allan, Mark <[EMAIL PROTECTED]> wrote:
>
>
> Thanks to both Christian Smith and John Stanton for your posts.
>
> > On Wed, 19 Oct 2005, Christian Smith wrote:
> > From the VDBE output you originally posted,
Thanks to both Christian Smith and John Stanton for your posts.
> On Wed, 19 Oct 2005, Christian Smith wrote:
> From the VDBE output you originally posted, you are doing a
> fair amount of
> work for each deleted row:
> - Index search to find the next row from EXAMINATIONS to delete
> - Removing
collisions. Doing this will leave a single index update in
addition to the actual row removals, which should improve performance.
>
>Best Regards
>
>Mark
>
Christian
>
>
>-Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: 18
05 19:06
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Very Slow delete times on larger databases, please
help!
"Allan, Mark" <[EMAIL PROTECTED]> wrote:
Have you been able to investigate this yet?
I have investigated and I found nothing wrong. I am unable
to reproduce th
nal Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 18 October 2005 19:06
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Very Slow delete times on larger databases, please
help!
"Allan, Mark" <[EMAIL PROTECTED]> wrote:
> Have you been able to investig
"Allan, Mark" <[EMAIL PROTECTED]> wrote:
> Have you been able to investigate this yet?
I have investigated and I found nothing wrong. I am unable
to reproduce the problem.
--
D. Richard Hipp <[EMAIL PROTECTED]>
@sqlite.org
Subject: Re: [sqlite] Very Slow delete times on larger databases, please
help!
"Allan, Mark" <[EMAIL PROTECTED]> wrote:
> We are experiencing incredibly slow delete times when deleting a
> large number of rows:-
>
> We are using SQLite on an embdedded platform with
"Allan, Mark" <[EMAIL PROTECTED]> wrote:
> We are experiencing incredibly slow delete times when deleting a
> large number of rows:-
>
> We are using SQLite on an embdedded platform with an ARM7 processor,
> 2Mb RAM and 32Mb NOR Flash memory 25Mb of which is allocated for
> storage for our datab
10 matches
Mail list logo