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
> 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 |
+-+
| | |
| | |
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
> "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
>>
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 :)
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> 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
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
8 matches
Mail list logo