[sqlite] 64bit DLL vs 32bit

On 2016-05-07 01:29, Simon Slavin wrote: > On 7 May 2016, at 3:28am, Keith Medcalf wrote: > >> I presume you mean that running 32-bit application on a 64-bit OS is >> slower than the same application run on a 32-bit OS. > > Hold on. The original poster was talking about using a 32-bit DLL,

[sqlite] Sorting by month with two dates input

Greetings! I have to create some reporting and I need to report on customers amount1 and amount2 two based on the whole year of 2013. There are two dates that are to be used as input: billdate and bdate. I can do one or the other, but, I can not seem to get the correct date when using

Re: [sqlite] Performance issue with JOIN and large IN operator

"Richard Hipp" wrote... On Wed, May 1, 2013 at 11:24 AM, Richard Hipp wrote: On Wed, May 1, 2013 at 8:30 AM, Martin Altmayer < martin.altma...@googlemail.com> wrote: Hi, I have a query that runs more than 400x slower in 3.7.16.2 than in 3.7.11. This seems to be

Re: [sqlite] SQLite version 3.7.16.2

"Stephen Chrzanowski" wrote... For the fifth time. ;) It's probably more like 6th or 7th. He he he he... On Sun, Apr 14, 2013 at 2:28 PM, jic <cabr...@wrc.xerox.com> wrote: "Roger Binns" wrote... -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 1

Re: [sqlite] SQLite version 3.7.16.2

"Roger Binns" wrote... -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 13/04/13 14:55, jose isaias cabrera wrote: Can this problem also from a DB file shared via Windows Shared folder An effective way to corrupt your data is to use a networked filesystem. They do not provide the exact

Re: [sqlite] Informal question

"Simon Slavin" asked... Although there are many hobbyist programmers here, many of us are clearly using SQLite for our serious day jobs, and not just for playing with. So why is this list busy over the weekends rather than during the working week ? We are putting in place what we got