Re: [sqlite] Default ordering of SELECT query (Clemens Ladisch)

2016-10-05 Thread R Smith
On 2016/10/05 5:27 PM, Andrii Motsok wrote: Date: Mon, 3 Oct 2016 16:25:09 +0200 Hi, 1) In case of ORDER BY if we choose ordering which does not follow "index ordering" we will get performance degradation. 2) If we use ORDER BY can we be sure that order of rows is the same for two

Re: [sqlite] Default ordering of SELECT query (Clemens Ladisch)

2016-10-05 Thread Andrii Motsok
Date: Mon, 3 Oct 2016 16:25:09 +0200 From: Clemens Ladisch To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Default ordering of SELECT query Message-ID: Content-Type: text/plain; charset=utf-8 >>Andrii Motsok