How does $ time sqlite3 test32k.db "select count(1) from role_exist"
perform? On Thu, Apr 1, 2010 at 5:52 AM, Alexey Pechnikov <pechni...@mobigroup.ru>wrote: > Hello! > > $ time sqlite3 test32k.db "select count(*) from role_exist" > 12500000 > > real 0m58.908s > user 0m0.056s > sys 0m0.864s > > $ sqlite3 test32k.db > SQLite version 3.6.23 > sqlite> .schema role_exist > CREATE TABLE role_exist ( > id INTEGER PRIMARY KEY, > uid BLOB NOT NULL DEFAULT (randomblob(16)) UNIQUE ON CONFLICT REPLACE > ); > > So 58s for count of all records! The count(*) for all records may use > the counter from primary key b-tree, is't it? > ============== > HARDWARE: > > $ grep CPU /proc/cpuinfo > model name : Intel(R) Core(TM)2 Quad CPU Q6700 @ 2.66GHz > model name : Intel(R) Core(TM)2 Quad CPU Q6700 @ 2.66GHz > model name : Intel(R) Core(TM)2 Quad CPU Q6700 @ 2.66GHz > model name : Intel(R) Core(TM)2 Quad CPU Q6700 @ 2.66GHz > > $ free > total used free shared buffers cached > Mem: 8310892 7552880 758012 0 29496 6667708 > -/+ buffers/cache: 855676 7455216 > Swap: 3903784 301240 3602544 > > Best regards, Alexey Pechnikov. > http://pechnikov.tel/ > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- VerifEye Technologies Inc. 905-948-0015x245 7100 Warden Ave, Unit 3 Markham ON, L3R 8B5 Canada _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
