Re: [sqlite] question on speed - or what am I doing wrong

On Sep 16, 2004, at 14:47, [EMAIL PROTECTED] wrote: What do I have to do to make this faster? And reading? Please, give me a concrete answer with examples if possible... http://www.sqlite.org/cvstrac/wiki?p=PerformanceConsiderations -- Tito

Re: [sqlite] question on speed - or what am I doing wrong

<[EMAIL PROTECTED]> writes: > 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','Bilja

Re: [sqlite] question on speed - or what am I doing wrong

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.d

[sqlite] question on speed - or what am I doing wrong

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