Re: [sqlite] group_replace

2016-08-15 Thread E.Pasma
11 aug 2016, Dominique Devienne: On Thu, Aug 11, 2016 at 1:10 PM, Anthony Lansbergen wrote: Hello, I needed a way to make parameterized texts for logging in my current project. For this purpose I missed a function in sqlite: group_replace, so I made an extension. The

Re: [sqlite] 64-bit SQLite3.exe

2016-08-15 Thread Rousselot, Richard A
Correction on description: Test 2: 32-bit 3.13 (sqlite.org), with PRAGMA but not temp_store = 2; -Original Message- From: Rousselot, Richard A Sent: Monday, August 15, 2016 12:20 PM To: sqlite-users@mailinglists.sqlite.org Cc: Rousselot, Richard A Subject: Re: [sqlite] 64-bit SQLite3.exe

Re: [sqlite] 64-bit SQLite3.exe

2016-08-15 Thread Rousselot, Richard A
Speed improvements based on 64-bit Visual Studio build. SQLite 3.14.0, built with MSVC 18.00.30723 for x64. Built with VS options /O2 /Ot /Ox. Built with SQLITE options of SQLITE_ENABLE_FTS3 SQLITE_ENABLE_STAT2 SQLITE_ENABLE_RTREE. Module SQL Script (146k records)T1 Sec T2 Sec T3 Sec