Re: [sqlite] Release 3.7.8 CREATE INDEX slower

2011-11-17 Thread Dan Kennedy
On 11/17/2011 03:22 AM, Faught, Bill wrote: I have a table of 3M rows. I add all the rows to the table, then call CREATE INDEX. Release 3.7.8 is about 40% slower than the previous release doing the CREATE INDEX. Has anyone else experienced this? 3.7.8 builds indexes differently. It uses a me

Re: [sqlite] Release 3.7.8 CREATE INDEX slower

2011-11-17 Thread Simon Slavin
On 16 Nov 2011, at 8:22pm, Faught, Bill wrote: > I have a table of 3M rows. I add all the rows to the table, then call > CREATE INDEX. > > Release 3.7.8 is about 40% slower than the previous release doing the > CREATE INDEX. > > Has anyone else experienced this? Do you still have a copy of th

[sqlite] Release 3.7.8 CREATE INDEX slower

2011-11-17 Thread Faught, Bill
I have a table of 3M rows. I add all the rows to the table, then call CREATE INDEX. Release 3.7.8 is about 40% slower than the previous release doing the CREATE INDEX. Has anyone else experienced this? ___ The contents of this e-mail a