Re: [sqlite] Implementation check request

2010-08-28 Thread Marcus Grimm
> > On 28 Aug 2010, at 4:24pm, Max Vlasov wrote: > >> I don't know whether my posts have a delay with delivery (replied >> several >> hours ago to the discussion you mentioned), but actually I tested 100 >> rows >> before and after with a similar query (ORDER BY LIMIT) and it definitely >> shows

Re: [sqlite] Implementation check request

2010-08-28 Thread Simon Slavin
On 28 Aug 2010, at 4:24pm, Max Vlasov wrote: > I don't know whether my posts have a delay with delivery (replied several > hours ago to the discussion you mentioned), but actually I tested 100 rows > before and after with a similar query (ORDER BY LIMIT) and it definitely > shows that sqlite

Re: [sqlite] Implementation check request

2010-08-28 Thread Max Vlasov
Simon, I don't know whether my posts have a delay with delivery (replied several hours ago to the discussion you mentioned), but actually I tested 100 rows before and after with a similar query (ORDER BY LIMIT) and it definitely shows that sqlite saves time and doesn't go further. Do you have

[sqlite] Implementation check request

2010-08-28 Thread Simon Slavin
Can someone check the source code for me ? Or perhaps this can be found from a query plan or something. A current discussion reminded me that something was never settled to my satisfaction. If I use LIMIT in a SELECT, e.g. SELECT name,address,(residents-1) FROM contacts WHERE postcode>'N"