to take care of this myself,
particularly with a table rename.
RBS
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: 06 February 2008 20:27
To: General Discussion of SQLite Database
Subject: Re: [sqlite] when to analyze?
&qu
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> Suppose we have a table with some 10 million rows and this table was
> analysed, so sqlite_stat1 has the stats of this table then is it worth it to
> analyze again after adding say 1000 more rows? The indexing is still the
> same, so no indexes are
Suppose we have a table with some 10 million rows and this table was
analysed, so sqlite_stat1 has the stats of this table then is it worth it to
analyze again after adding say 1000 more rows? The indexing is still the
same, so no indexes are dropped or created. Also the data of the added rows
3 matches
Mail list logo