[sqlite] Sqlite good on Windows XP but very very slow on Windows Seven

2015-10-17 Thread Stephan Beal
On Sat, Oct 17, 2015 at 9:53 PM, Lucas Ratusznei Fonseca < lucas.ratusznei at gmail.com> wrote: > Hi all, > > I am using sqlite for years with my software on Windows XP, no more than 1 > or 2 milliseconds per transaction (insert), so speed has never been a > concern. Until now. > I had to migrate

[sqlite] Compilation fails under Linux (Ubuntu) when FTS5 is enabled

2015-10-17 Thread to...@acm.org
I'm trying to compile the shell using the amalgamation (three files involved: shell.c sqlite3.c sqlite.h). This is a process I've done a zillion times before without problems. The only new thing I did was add the -DSQLITE_ENABLE_FTS5 to command line. (Adding the -lm switch did not help.)

[sqlite] Sqlite good on Windows XP but very very slow on Windows Seven

2015-10-17 Thread Simon Slavin
On 17 Oct 2015, at 8:53pm, Lucas Ratusznei Fonseca wrote: > I am using sqlite for years with my software on Windows XP, no more than 1 > or 2 milliseconds per transaction (insert), so speed has never been a > concern. Until now. > I had to migrate my system to Windows Seven recently, I am still

[sqlite] Compilation fails under Linux (Ubuntu) when FTS5 is enabled

2015-10-17 Thread Simon Slavin
On 17 Oct 2015, at 8:21pm, tonyp at acm.org wrote: > I'm trying to compile the shell using the amalgamation (three files involved: > shell.c sqlite3.c sqlite.h). > This is a process I've done a zillion times before without problems. > The only new thing I did was add the -DSQLITE_ENABLE_FTS5 to

[sqlite] Compilation fails under Linux (Ubuntu) when FTS5 is enabled

2015-10-17 Thread Dan Kennedy
On 10/17/2015 06:47 PM, tonyp at acm.org wrote: > What the subject says and I get this error: > > /tmp/cco8QBGJ.o: In function `fts5Bm25GetData': > sqlite3.c:(.text+0xb521b): undefined reference to `log' > > (using the latest 3.9.1 release) You'll need to add "-lm" to the command line. Was this

[sqlite] Sqlite good on Windows XP but very very slow on Windows Seven

2015-10-17 Thread Lucas Ratusznei Fonseca
Hi all, I am using sqlite for years with my software on Windows XP, no more than 1 or 2 milliseconds per transaction (insert), so speed has never been a concern. Until now. I had to migrate my system to Windows Seven recently, I am still doing tests and stuff. It happens that some processes

[sqlite] Sqlite good on Windows XP but very very slow on Windows Seven

2015-10-17 Thread Keith Medcalf
Have you checked the options that are set for the Hard Drive Controller and Drives? (Particularly the ones that disable OS and hardware cache flushing). Perhaps Windows 7 drivers are doing an fsync when fync is called. 120 ms per transaction is pretty good for a machine that is working

[sqlite] Compilation fails under Linux (Ubuntu) when FTS5 is enabled

2015-10-17 Thread to...@acm.org
What the subject says and I get this error: /tmp/cco8QBGJ.o: In function `fts5Bm25GetData': sqlite3.c:(.text+0xb521b): undefined reference to `log' (using the latest 3.9.1 release) Any ideas? Thanks.

[sqlite] Compilation fails under Linux (Ubuntu) when FTS5 is enabled

2015-10-17 Thread Christian Schmitz
> Am 17.10.2015 um 13:47 schrieb tonyp at acm.org: > > What the subject says and I get this error: > > /tmp/cco8QBGJ.o: In function `fts5Bm25GetData': > sqlite3.c:(.text+0xb521b): undefined reference to `log' > > (using the latest 3.9.1 release) > > Any ideas? For me it worked on a 32bit and

[sqlite] Sqlite good on Windows XP but very very slow on Windows Seven

2015-10-17 Thread Darren Duncan
There's also the obvious question of, what SQLite version are you using on each OS? -- Darren Duncan On 2015-10-17 12:57 PM, Simon Slavin wrote: > > On 17 Oct 2015, at 8:53pm, Lucas Ratusznei Fonseca gmail.com> wrote: > >> I am using sqlite for years with my software on Windows XP, no more than