[sqlite] New wiki page for Performance Tuning

2004-01-15 Thread Greg Obleshchuk
Hi All, I just created a new wiki page off the wiki home called PerformanceTuning. I have started to place clipets from emails in the group which relate to making queries or DB operations run quicker. Please add your bits and pieces http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuning

Re: [sqlite] sqlite command-line utility (was: manual? documentat ion?)

2004-01-15 Thread Kennedy, Dan
> What does the... > "(one varchar(10), two smallint)" > ...in the following example... > "sqlite> create table tbl1(one varchar(10), two smallint);" > ...mean/do? It creates the table 'tbl1' shaped like this. +-+ | one | two | +-+ | | | | | |

[sqlite] Autoincrement not sequential

2004-01-15 Thread Balthasar Indermuehle
Hi all, I'm writing a little performance tester app for sqlite (which btw so far produces very impressive results!). I'm filling 100,000 records into a table where the first field is a "integer primary key" so as to let it increment the number on insert automatically. Interestingly, it doesn't

Re: [sqlite] Close() and file locks...

2004-01-15 Thread Jeremy Hinegardner
> "eno" == eno <[EMAIL PROTECTED]> writes: eno> Marco Bambini wrote: >> After the 2.8.10 release ... "This version fixes a critical locking >> bug in Unix. It turns out that any call to close() clears all locks >> on file that was closed (who knew?) which then left the database >>

[sqlite] vdbe question

2004-01-15 Thread ivan
hi how can i create vdbe for same special sql query, then check how many row a will get, and for example move to row 100 and fetch 20 rows , its could be just sql cursor but i didn't find it in sqlite .. what can i do about it ? thanks :)

[sqlite] Decodes

2004-01-15 Thread Drew, Stephen
Hi, Are there any plans to include a DECODE as a standard built-in function in SQLite? I have written one myself very easily, and it seems to be a nice, quick feature to add. Regards, Steve

[sqlite] Cannot drop trigger

2004-01-15 Thread Kurt Welgehausen
sqlite> drop trigger xx; SQL error: no such trigger: xx sqlite> select name, length(name) from sqlite_master ...> where type='trigger' and name like '%xx%'; xx|2 sqlite> pragma integrity_check; ok I had to dump the database and recreate it to get rid of the trigger. I kept a

[sqlite] tcl tests on 2.8.11

2004-01-15 Thread Avner Levy
I've run it on linux and windows and got the same failures. Did anybody run the test suit on the new version ? Thanks Avner The test output: date-8.1... Expected: [{2003-10-26 12:34:00}] Got: [{2004-01-18 15:31:14}] date-8.2... Expected: [{2003-10-27 12:34:00}] Got: [{2004-01-19