Matt Sergeant wrote:
On Thu, 22 Jul 2004, D. Richard Hipp wrote:
Two new versions of SQLite are available on the website.
See the news column on the right for details.
http://www.sqlite.org/
Did 3.0.3 have a very negative effect on create/drop table speed? I have a
benchmark in the DBD::SQLite test suite that has suddenly dropped off the
chart in speed terms.
Below a speed comparison betwen 3.0.1 and 3.0.3 for creating and
droping 500 tables with multiple indices. 3.0.3 is a little faster.
Test 1: 500 CREATE TABLES, CREATE INDEXes, and INSERTs
BEGIN
CREATE TABLE t1(a,b UNIQUE, c PRIMARY KEY);
CREATE INDEX i1 ON t1(a);
... 1496 lines omitted
CREATE INDEX i500 ON t500(a);
INSERT INTO t500 VALUES(1,2,3);
COMMIT
sqlite301a 2004-Jun-25 13.455 2114KB
sqlite303a 2004-Jul-22 12.484 2114KB
Test 2: 500 DROPs
BEGIN
DROP TABLE t1;
DROP TABLE t2;
... 496 lines omitted
DROP TABLE t499;
DROP TABLE t500;
COMMIT
sqlite301a 2004-Jun-25 4.483 2114KB
sqlite303a 2004-Jul-22 4.372 2114KB
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
