Manzoor Ilahi Tamimy wrote: > sqlite3_exec(db, "create table t (a integer, b float, c text,d integer, > e float, f text, g float, h text)", NULL, NULL, NULL); > > sqlite3_exec(db, "begin transaction", NULL, NULL, NULL); > > sqlite3_prepare(db, "insert into t values (?, ?, ?, ?, ?, ?, ? , ?)", -1, > &insert, NULL); .. > I really Need Help.
You certainly do. 1) Your test program is not testing what you want to test, because you have not defined any indexes on the table. > CREATE TABLE HVH ( > Field1 VARCHAR(8), IDC VARCHAR(4), > Field3 VARCHAR(2), Field4 VARCHAR(4), > Field5 VARCHAR(7), Field6 VARCHAR(8), > Field7 VARCHAR(1), Field8 FLOAT); > > CREATE TABLE ITM( > IDC VARCHAR(4), ITEMNAME VARCHAR(20), > COLUMN3 VARCHAR(1), COLUMN4 VARCHAR(1), > COLUMN5 VARCHAR(1), COLUMN6 VARCHAR(1), > COLUMN7 VARCHAR(1), COLUMN8 VARCHAR(1), > COLUMN9 VARCHAR(1), COLUMN10 VARCHAR(1), > COLUMN11 VARCHAR(1), COLUMN12 VARCHAR(1), > COLUMN13 VARCHAR(1), COLUMN14 VARCHAR(1), > COLUMN15 VARCHAR(1), COLUMN16 VARCHAR(1)); > > CREATE INDEX index1 ON ITM (IDC); .. > Select count(*) from itm, HVH where itm .IDC = HVH.IDC 2) Your original schema is always going to be slow, because you have not defined a suitable index on HVH(IDC). -- Nikki Locke, Trumphurst Ltd. PC & Unix consultancy & programming http://www.trumphurst.com/
