[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%). Ther

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 ret

Re: [sqlite] Index test on 3.0.7

Federico Granata wrote: 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

[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 test-index.db

Re: [sqlite] function of lemon and temp in Makefile?

Saturday, September 25, 2004, 10:42:26 AM, Daniel wrote: > While executing make install "./lemon" and "./temp" are exetuted. > Can anybody tell me, what they do exactly? ./lemon generates the C source code of the SQL parser from a grammar file You can get the generated parse.c and parse.h from

[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 e