Re: [sqlite] When to run ANALYZE

2015-01-19 Thread Simon Slavin
> 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

[sqlite] When to run ANALYZE

2015-01-19 Thread Andy (KU7T)
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 ___

RE: [sqlite] When to run analyze?

2006-12-01 Thread RB Smissaert
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: > &g

Re: [sqlite] When to run analyze?

2006-12-01 Thread drh
"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? >

RE: [sqlite] When to run analyze?

2006-12-01 Thread RB Smissaert
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, overa

RE: [sqlite] When to run analyze?

2006-12-01 Thread RB Smissaert
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 &g

Re: [sqlite] When to run analyze?

2006-12-01 Thread drh
"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

Re: [sqlite] When to run analyze?

2006-12-01 Thread drh
"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

Re: [sqlite] When to run analyze?

2006-12-01 Thread P Kishor
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

[sqlite] When to run analyze?

2006-12-01 Thread RB Smissaert
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