[sqlite] Speed comparison (was: [sqlite] Lock files....)

b.bum ([EMAIL PROTECTED]) wrote: > SQLite3 produces smaller data files thats true, > and is faster, in general, than did SQLite2. but this is not my experience. In my small applications (about 20 records) inserting and searching with SQLite 3.0 is slower than SQLite 2.8 (about 25%).

Re: [sqlite] A problem with the select statement

Yogesh Marwaha wrote: > Hi! > > I am using sqlite 3.05 beta. I have created a table containing a field named > 'title'. When I run the SQL Command : - > > select count(*) from master_table where title = "title" > > output is 885, i.e. count of all the rows in the table, whereas it should > have

[sqlite] A problem with the select statement

Hi! I am using sqlite 3.05 beta. I have created a table containing a field named 'title'. When I run the SQL Command : - select count(*) from master_table where title = "title" output is 885, i.e. count of all the rows in the table, whereas it should have returned the number of rows in which

[sqlite] Index test on 3.0.7

Hi, I'm testing index on sqlite ver 3.0.7. I've create a really simple database CREATE TABLE tbl1(rowid integer primary key,fld1 text,fld2 integer); and fill it with 100 row like this insert into tbl1(fld1,fld2) values("blablablablablablabla",759928); Then I copy this test.db to

[sqlite] function of lemon and temp in Makefile?

While executing make install "./lemon" and "./temp" are exetuted. Can anybody tell me, what they do exactly? Thanks, Daniel [EMAIL PROTECTED] build]# make install sed -e s/--VERS--/`cat ./../VERSION`/ \ . . . gcc -g -O2 -o temp temp.c ./temp >config.h echo >>config.h rm -f temp.c temp