Dear all,
Just to give some feedback on this problem : I changed the HDD of my
client, and configured his anti-virus to exclude the database directory.
I don't know which one of those actions solved the problem, but it now
seems to work like a charm. I will still wait a few days/weeks to be sure
On 10 Nov 2015, at 8:18am, OBones wrote:
> However, using tools to read the SMART values for this harddrive, I noticed
> that it had been eating up spare sectors for quite a while.
That's actually a good suggestion for you: look at the SMART values, run any
hard disk diagnostics you have, etc
Brice Andr? wrote:
> So, my question is the following : does someone has already experienced
> performance issues on database with an HDD device starting to fail (without
> any corruption problem) ? And if yes, is it possible that those performance
> issues come with no notification in the windows
Also look for failures at the bus level. I have had cases where some
component was mucking up the bus, and got long pauses because the OS kept
resetting the bus. These caused huge pauses, like 30 seconds or more, and
due to how various OS components mostly do synchronous disk access, that
kind of
Dear all,
Thank you very much for those advices. I will try them and get back if it
does not solve the issue.
Regarding the advice of Simon on HDD starting to fail, I have one more
question. In fact, I suspected this, as my client has other problems with
his computer. But, in such case, I expecte
On 2015/11/09 6:33 PM, Brice Andr? wrote:
> OK, but if this scenario was at the origin of my problem, I guess I would
> have such a log each time a db query freezes ?
>
> If yes, then there is probably another problem, as I am sure I got such
> freezes with no such logs from sqlite.
>
> By the wa
OK, but if this scenario was at the origin of my problem, I guess I would
have such a log each time a db query freezes ?
If yes, then there is probably another problem, as I am sure I got such
freezes with no such logs from sqlite.
By the way, if the antivirus is at the origin of the problem, whi
On Mon, Nov 9, 2015 at 4:41 PM, R Smith wrote:
> All this assumes it /IS/ in fact the anti-virus causing the problem - you
> need to check that first.
Just let him run with the AV disabled for a while or ignore the folder
and try to replicate the problem.
However, I would **uninstall the program
Dear Richard,
Thanks for your answer. The version of sqlite I am using is the 3.9.1
amalgamation.
But, as stated above, I am not sure my freeze problem is linked to the
strange log observed at my client as this log does not systematically
appears on database queries that freeze. Those logs someti
On 9 Nov 2015, at 3:21pm, Brice Andr? wrote:
> So, does someone has an idea on what can cause such performance issues on
> some sqlite DB requests ?
Since you
1) are getting delays and not errors, and
2) you are using very common OS and hardware, and
3) you are accessing a database from an int
Dear all,
I experience some performance issues with SQLite.
I have an application that uses SQLite to store user data, including agenda
information. One of my client has a relatively big database (around 1.3Gb).
I have indexed the database so that the queries take a reasonable time to
execute.
I
On 11/9/15, Brice Andr? wrote:
> OK, but if this scenario was at the origin of my problem, I guess I would
> have such a log each time a db query freezes ?
>
> If yes, then there is probably another problem, as I am sure I got such
> freezes with no such logs from sqlite.
>
> By the way, if the an
So the problem is occurring on a call to GetFileAttributesEx().
I'm guessing that this is an adverse interaction with an anti-virus
(AV) program.
The scenario might be something like this.
(1) SQLite writes one small part of a complex change to the database file
(2) The AV seizes control and sca
On 11/9/15, Brice Andr? wrote:
>
> 08-11-2015 (13h25): Exception: SQLiteDataBase : Error callback -> 27 :
> delayed 25ms for lock/sharing conflict at line 39428
The "line 39428" refers to a specific source code line number in the
"sqlite3.c" file, which in turn depends on exactly which version of
I am not a user of Norton but I expect it has the same features as others.
In Windows Defender you can specify files to exclude and that may help.
*Jim Dodgen*
On Mon, Nov 9, 2015 at 8:44 AM, Richard Hipp wrote:
> On 11/9/15, Brice Andr? wrote:
> > OK, but if this scenario was at the ori
15 matches
Mail list logo
