Re: [sqlite] 64-bit SQLite3.exe

Yes, it is much faster. The process was done in Excel/Access before and took ages. I have had processes go from 8 hours before to 30 min now using SQLite. -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Michael Gratton Sent:

Re: [sqlite] SpeedTest1 Comparison of 32 vs 64 bit on Windows 10 13483.15

Nice Keith, and very topical as well as being informative. Note a couple of things that got my curiosity chip activating: *subquery in result set* test produces interesting outcome with the 64 bit version bucking the trend. Any ideas there? Also it would appear *select* clauses demonstrate an

Re: [sqlite] 64-bit SQLite3.exe

Yes Richard, in my experience your quoted time benefits are very much on target. I have rewritten Excel/Access (VBA) which I originally developed (and was quite proud of). Re-writes using C/C++ and SQLite indeed delivered the performance gains you experienced and relieved me of the pain

Re: [sqlite] C API - Parameterized Atomic Transactions

On Tue, 9 Aug 2016 17:09:39 -0300 Paulo Roberto wrote: > I would like something like this: > > "BEGIN EXCLUSIVE TRANSACTION;" > "SELECT counter FROM mytable WHERE counterid = ?;" > "UPDATE mytable SET counter=? WHERE counterid = ?;" > "COMMIT TRANSACTION;"

Re: [sqlite] Bug in CREATE INDEX

On Mon, 8 Aug 2016 10:48:58 -0700 "Kevin O'Gorman" wrote: > Very cool. But 4? I will be running this on machines with 8 and 16 > cores. Does going beyond 4 not help much? Four doesn't seem like a bad starting point. I don't have any information specific to SQLite,

Re: [sqlite] Error File is Encrypted or is not a database

You are welcome.I was worried about the infinite loop I wrote. ;) Hopefully you can track down the reason, I don't know anything about your file but what you tell us. There are some things that you can do to help track it down. You didn't mention what version of sqlite you were using,

Re: [sqlite] Error File is Encrypted or is not a database

Thanks you very much! The information was very usefull. I can recover the database info now, overwritting the header array. Have you any information about how the header is corrupted? I would like to know the reason to resolve it. Thanks again! 2016-08-18 10:14 GMT-03:00 Adam Devita

Re: [sqlite] Error File is Encrypted or is not a database

Good day, A few things that you can try 1) One could download a hex editor and review the beginning of the file and compare to https://www.sqlite.org/fileformat2.html . If some other program has over-written the header, you should be able to observe that, hopefully identifying a program with a

Re: [sqlite] Error File is Encrypted or is not a database

1) One could download a hex editor and review the beginning of the file and compare to https://www.sqlite.org/fileformat2.html . If some other program has over-written the header, you should be able to observe that, hopefully identifying a program with a problem. 2) Back up you hard drive. Run

[sqlite] Error File is Encrypted or is not a database

Hi Everyone; I have a problem with a sqlite database that was working very good but suddenly started to give the message "File is encrypted or is not a database". Then I can´t access it and i have to replace it with a new one. Can anyone help me with this problem? I don´t know how to re-open the

Re: [sqlite] Error File is Encrypted or is not a database

On 18 Aug 2016, at 6:24pm, Matias Badin wrote: > Thanks you very much! The information was very usefull. > I can recover the database info now, overwritting the header array. Once you have the header array 'correct' and SQLite no longer refuses to open the database, use