Re: [sqlite] Functions and index

On 2011-06-27 17:34 Simon Davies wrote: > select julianday( ( select max( day_date ) from days ) ); Of course I tried this, but with a single bracket I got a syntax error. With double bracket it works. Thanks! Adam ___

[sqlite] Functions and index

I have hundred thousands of records in this table: CREATE TABLE days ( day_id INTEGER NOT NULL PRIMARY KEY, day_date DATE ); CREATE INDEX day_i ON days (day_date ASC); And then if I run such query: EXPLAIN QUERY PLAN SELECT JULIANDAY(MAX(day_date)) FROM days; 0|0|0|SCAN TABLE

Re: [sqlite] SQLite version 3.6.21

Original Message Subject: Re: [sqlite] SQLite version 3.6.21 From: Andreas Schwab To: sqlite-users@sqlite.org Date: 2009-12-08 02:41 > $ ./sqlite3 :memory: 'create table test(integer)' > Segmentation fault We have the same problem and with this posted

[sqlite] SQL functions - documentation?

Hi All, Is there any description of SQL functions which are implemented in SQLite? I mean functions like substr, mean, etc. (date and time functions have their documentation in wiki) Only in some source files of the SQLite? Regards, Adam

Re: [sqlite] LIMIT does not speed up query execution

Christian Smith wrote: > Query (2) has an extra condition in the WHERE clause, thus reducing > the result set size to be sorted. As sorting is probably an > O(n.log(n)) operation, halving the result set will more than halve > the time taken to sort, for example. Add that extra condition to >

[sqlite] LIMIT does not speed up query execution

Hi all! Since my database growed to more than 20 000 records, I have noticed that select limited to a few numer of records by LIMIT takes much more time than select limited to similar number of records by another WHERE condition. I use sqlite_get_table function. In my case I have the following