On 11/9/15, jungle Boogie wrote:
> On 8 November 2015 at 19:51, jungle Boogie wrote:
>> sqlite3 /home/jungle/fossil-repos/sqlite3/src/shell.c
>> ./.libs/libsqlite3.a -ledit -lpthread -Wl,-rpath -Wl,/usr/local/lib
>> /home/jungle/fossil-repos/sqlite3/src/shell.c:71:11: fatal error:
>>
On 11/9/15, Richard Hipp wrote:
> It is traditional, in a permuted index, to include the complete
> unedited title of each document in the index, even if that title
> begins with a stop-word. You'll notice that documents that have
> "SQLite" as an interior word are not listed among the "SQLite"
On 9 November 2015 at 19:29, Richard Hipp wrote:
> Works for me on OpenBSD 5.8. No issues at all.
Failing on freebsd with this make file:
https://www.sqlite.org/src/artifact/4469ed8b02a9934f
Introduced with this check-in:
https://www.sqlite.org/src/info/866f0277781dedf0
Commenting out line
Hello,
Could you please confirm that BLOBs created by
sqlite3_bind_blob64()/sqlite3_bind_zeroblob64() can still be read with
sqlite3_blob_read()/sqlite3_blob_bytes() or sqlite3_column_blob
/sqlite3_column_bytes() because their size can never exceed the limit
specified here:
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
On 9 Nov 2015, at 7:52pm, gwenn wrote:
> Could you please confirm that BLOBs created by
> sqlite3_bind_blob64()/sqlite3_bind_zeroblob64() can still be read with
> sqlite3_blob_read()/sqlite3_blob_bytes() or sqlite3_column_blob
> /sqlite3_column_bytes() because their size can never exceed the
On 8 November 2015 at 19:51, jungle Boogie wrote:
> sqlite3 /home/jungle/fossil-repos/sqlite3/src/shell.c
> ./.libs/libsqlite3.a -ledit -lpthread -Wl,-rpath -Wl,/usr/local/lib
> /home/jungle/fossil-repos/sqlite3/src/shell.c:71:11: fatal error:
> 'editline/readline.h' file not found
> # include
>
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,
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
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
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
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.
On 11/8/15, Zsb?n Ambrus wrote:
>
> 4. The permuted index
> "http://www.sqlite.org/draft/sitemap.html#pindex; has several entries
> starting with "SQLite". Most of those are superfluous, because the
> whole index is about SQLite documentation only. I think you should
> remove most of them.
It
Stephan Beal Sent: Saturday, November 07, 2015 3:54 AM
> On Fri, Nov 6, 2015 at 6:50 PM, Nelson, Erik - 2 <
> erik.l.nelson at bankofamerica.com> wrote:
>
> > I have a user-defined function something like
> >
> > void quarter_sqlite3(sqlite3_context *context, int argc,
> sqlite3_value
> >
On Sun, Nov 8, 2015 at 4:17 PM, Nicolas J?ger
wrote:
> people with non-latin-1 name knows problem too... even in their own country...
>
> regards,
> Nicolas
Yes, but I think this is getting better as there is more high-level
programming and better and more tested libraries being used. Still,
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
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
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
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
19 matches
Mail list logo
