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, but in general adding
cor
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;"
begin transaction;
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 associated
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 abo
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 the SQLite command-lin
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, program
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 :
> Good day
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: Wedn
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 ha
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 pr
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 d
11 matches
Mail list logo
