[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%). Therefore I stay with 2.8. Hans-Jürgen
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 returned the number of rows in which value of the field title is "title" > (which is actually 10). Perhaps sqlite is comparing value of column named > title with the column itself. > A string in double-quotes resolves to the name of a column if such a column is available. Use single-quotes to force the string to be interpreted as a string. SELECT count(*) FROM master_table WHERE title='title'; ^ ^ | | ' not " here -^-' -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
[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 value of the field title is "title" (which is actually 10). Perhaps sqlite is comparing value of column named title with the column itself. Can somebody please help, Yogesh M Chandigarh, India http://mylinuxapps.tripod.com
[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 and add a index (on test-index.db) CREATE INDEX ind1 on tbl1(fld2); When I do something like time sqlite3 test.db "select * from tbl1 where fld2=12345;" > /dev/null real0m3.879s user0m3.188s sys 0m0.650s and time sqlite3 test-index.db "select * from tbl1 where fld2=12345;" > /dev/null real0m0.019s user0m0.006s sys 0m0.006s I'm happy... index work very well... but... time sqlite3 test.db "select * from tbl1 where fld2>12345;" > /dev/null real0m21.452s user0m20.503s sys 0m0.809s and time sqlite3 test-index.db "select * from tbl1 where fld2>12345;" > /dev/null real1m15.840s user0m54.799s sys 0m16.131s make me very sad :( It's a bug or mine mistake ? P.S. Sorry for my english. -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: Dai più energia al tuo sport! Rigenera il tuo corpo in maniera naturale * Grazie agli integratori sport che trovi solo su Erboristeria.com Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=2379=25-9
[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 echo '/* Automatically generated file. Do not edit */' >opcodes.h grep '^case OP_' ./../src/vdbe.c | \ sed -e 's/://' | \ awk '{printf "#define %-30s %3d\n", $2, ++cnt}' >>opcodes.h gcc -g -O2 -o lemon ./../tool/lemon.c cp ./../tool/lempar.c . cp ./../src/parse.y . ./lemon parse.y ./libtool --mode=compile gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I. -I./../src -DNDEBUG -c ./../src/attach.c . . . _ Mit WEB.DE FreePhone? mit hochster Qualitat ab 0 Ct./Min. weltweit telefonieren! http://freephone.web.de/?mc=021201