I'm having problems with sqlite query speed - in fact it is very slow....
Fact 1: I'm using sqlite 2.8.14 Fact 2: my database file is named te2.db - and has one it's layout looks like this
create table tmaster ( broj integer primary key, datumblok date, vrijemeblok time, datumdeblok date, lokacija varchar(50), regbroj varchar(15), vlasnik varchar(25), adresa varchar (50), kompol varchar(25), radblok varchar(25), raddeblok varchar(25), nalog integer, zabiljeska integer, prekrsaj varchar(50), posljedica varchar(50), napomena varchar(200), foto1 varchar(200), foto2 varchar(200), foto3 varchar(200), foto4 varchar(200), foto5 varchar(200), foto6 varchar(200), unosilac varchar(8), datumunosa date, vrijemeunosa time);
create table tradnik ( id integer primary key, oznaka varchar(8), ime varchar(25));
create table tkompol ( id integer primary key, oznaka varchar(8), ime varchar(25));
create table tlokacija ( id integer primary key, oznaka varchar(50));
create table tprekrsaj ( id integer primary key, oznaka varchar(50), kazna float);
create table tposljedica ( id integer primary key, oznaka varchar(50));
create table tkorisnici ( id integer primary key, ime varchar(25), username varchar(8), password varchar(8), ovlast varchar(1));
create table tlogovanja ( id integer primary key, ime varchar(25), datum date, vrijeme time, uspjeh varchar(10));
create table topcije ( podesavanje varchar(100));
Fact 3: I've done command ".read q.txt" which contains over 15900 of:
insert into tmaster values(null,'01.01.2003','12:30','21.11.2004','Probna lokacija','232-k-212','Mico Micicevic','Stepe Stepanovica 17, 78000 Prnjavor','Drasko Ignjatic','Mirko Miric','Biljana Jeftic',212132,213213,'Parkirao na nedozvoljeno mjesto na trotoaru','Vozilo premjesteno na drugu lokaciju','Bio bezobrazan i prijetio, pokusao da osteti lisice','c:\zsike\!pika\proba.jpg','c:\mika\!pika\proba.jpg','mika.jpg','','','','admin','01.01.2003','12:30');
Fact 4: It took over a 20 minutes to execute this query and te2.db now takes about 21,7MB. I've done it twice, to make sure.
What do I have to do to make this faster? And reading? Please, give me a concrete answer with examples if possible...
Thanks in advance,
b
