[sqlite] sqlite ext3 settings

Hi, I have sqlite database on top of ext3 (on ssd). Does 1) ext3 parameters (data=writeback|ordered,barrier=0|1, etc) 2) drive write-caching setting (hdparm -W) value 3) ??? have impact on the possibility of losing data due to power loss? If yes which parameters should be used to

Re: [sqlite] Default ordering of SELECT query

>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. >

[sqlite] transaction during reading on read-only database

Hi, My understanding is that any reading from database automatically starts read transaction. The question: why does sqlite need to do it on read-only database? Regards, Andrii ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

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

Date: Mon, 3 Oct 2016 16:25:09 +0200 From: Clemens Ladisch <clem...@ladisch.de> To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Default ordering of SELECT query Message-ID: <dc6a07e2-2aed-7512-0483-77c1fd204...@ladisch.de> Content-Type: text/plain; charset=utf-8 >

[sqlite] Default ordering of SELECT query

Hi, Sqlite man (https://www.sqlite.org/lang_select.html) [https://sqlite.org/images/syntax/select-stmt.gif] SQLite Query Language: SELECT www.sqlite.org The SELECT statement is used to query the database. The

Re: [sqlite] switching from WAL to DELETE mode (Clemens Ladisch)

. Re: Bug in CREATE INDEX (Philip Newton) -- Message: 1 Date: Sun, 7 Aug 2016 15:20:21 +0200 From: Clemens Ladisch <clem...@ladisch.de> To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] switching from WAL to DELETE mode Message-ID: <3ac6c8eb-d10d-7bca-b33c-9e37e81da...@ladisch.de> Co

[sqlite] switching from WAL to DELETE mode

Hi, Is that possible to switch database from WAL to DELETE mode when holding more than one connection? If no, which workaround could we use to omit closing of 'all-except-one' connections? Regards, Andrii ___ sqlite-users mailing list