use begin transaction, commit transaction and do allinserts between those Bert
Op donderdag 16 september 2004 14:47, schreef [EMAIL PROTECTED]: > 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 -- met vriendelijke groet Bert Verhees ROSA Software
