> On 19 Jan 2015, at 4:11pm, Andy (KU7T) wrote:
>
> ANALYZE
>
> ANALYZE sqlite_master
>
>
>
> To my app at timely intervals. We are also running in WAL mode. Do I need to
> do a WAL checkpoint (pragma wal_checkpoint) before running the index recalc
> or not?
You don't even need the ANALYZE
Hi,
I added a call to both:
ANALYZE
ANALYZE sqlite_master
To my app at timely intervals. We are also running in WAL mode. Do I need to
do a WAL checkpoint (pragma wal_checkpoint) before running the index recalc
or not?
Thanks
Andy
___
OK, have sent the file to [EMAIL PROTECTED]
RBS
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 02 December 2006 00:00
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] When to run analyze?
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> >
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> > And also the output of running sqlite3_analyzer on your database
>
> Have run that now and the output looks impressive, although I have no idea
> yet how to use it. Output file is 72 Kb. Shall I send it as an attachement
> to this user-group?
>
Direc
TED] [mailto:[EMAIL PROTECTED]
Sent: 01 December 2006 21:01
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] When to run analyze?
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> Having a reasonably big SQLite database, 21 tables, one table with some
> millions of rows, overall fil
21:01
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] When to run analyze?
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> Having a reasonably big SQLite database, 21 tables, one table with some
> millions of rows, overall file size about 1.3 Gb. This table will only get
>
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> Having a reasonably big SQLite database, 21 tables, one table with some
> millions of rows, overall file size about 1.3 Gb. This table will only get
> SELECT statements once it has been created. I have now run analyze on this
> file and it does speed quer
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> Having a reasonably big SQLite database, 21 tables, one table with some
> millions of rows, overall file size about 1.3 Gb. This table will only get
> SELECT statements once it has been created. I have now run analyze on this
> file and it does speed quer
On 12/1/06, RB Smissaert <[EMAIL PROTECTED]> wrote:
Having a reasonably big SQLite database, 21 tables, one table with some
millions of rows, overall file size about 1.3 Gb. This table will only get
SELECT statements once it has been created. I have now run analyze on this
file and it does speed
Having a reasonably big SQLite database, 21 tables, one table with some
millions of rows, overall file size about 1.3 Gb. This table will only get
SELECT statements once it has been created. I have now run analyze on this
file and it does speed queries up indeed.
Do I run analyze after the table h
10 matches
Mail list logo