-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/26/2011 03:12 AM, Black, Michael (IS) wrote:
> When you say "All an index does" don't forget that an index is also usually
> smaller than the data, thereby increase cache performance and reducing disk
> seeks.
That is muddied in the case
e Database
Subject: EXT :Re: [sqlite] Full Table Scan after Analyze
On 25 Mar 2011, at 11:11pm, Jay A. Kreibich wrote:
> On Fri, Mar 25, 2011 at 10:30:59PM +, Simon Slavin scratched on the wall:
>
>> Actually I'm surprised and not terribly impressed that SQLite ever
>> does
On 25 Mar 2011, at 11:11pm, Jay A. Kreibich wrote:
> On Fri, Mar 25, 2011 at 10:30:59PM +, Simon Slavin scratched on the wall:
>
>> Actually I'm surprised and not terribly impressed that SQLite ever
>> does a scan when there's an ideal index available.
>
> Why? Do you want it to run
On Fri, Mar 25, 2011 at 10:30:59PM +, Simon Slavin scratched on the wall:
> Actually I'm surprised and not terribly impressed that SQLite ever
> does a scan when there's an ideal index available.
Why? Do you want it to run slower?
Indexes are not magic bullets. Using an index to
> Suggestion: After you run ANALYZE, go back and modify values in
> sqlite_stat1 (and sqlite_stat2 if you are using SQLITE_ENABLE_STAT2) with
> "typical" values that you would expect to see in most databases. Yes, you
> can read and write the sqlite_stat1 and sqlite_stat2 tables. Maybe you can
On Fri, Mar 25, 2011 at 6:30 PM, Simon Slavin wrote:
>
> On 25 Mar 2011, at 10:18pm, Richard Hipp wrote:
>
> > Suggestion: After you run ANALYZE, go back and modify values in
> > sqlite_stat1 (and sqlite_stat2 if you are using SQLITE_ENABLE_STAT2) with
> > "typical" values
On 25 Mar 2011, at 10:18pm, Richard Hipp wrote:
> Suggestion: After you run ANALYZE, go back and modify values in
> sqlite_stat1 (and sqlite_stat2 if you are using SQLITE_ENABLE_STAT2) with
> "typical" values that you would expect to see in most databases. Yes, you
> can read and write the
On Fri, Mar 25, 2011 at 5:24 PM, Eric Minbiole wrote:
> We have an application that has been using SQLite successfully for several
> years. We use SQLite for various purposes within our product, with a few
> dozen tables overall.
>
> Recently, I started to upgrade from
We have an application that has been using SQLite successfully for several
years. We use SQLite for various purposes within our product, with a few
dozen tables overall.
Recently, I started to upgrade from version 3.6.3 to 3.7.5. During that
time, I noticed that several previously fast indexed
9 matches
Mail list logo