> When testing, it is my usual practice to compile with
> -DSQLITE_NO_SYNC=1 which turns off disk syncing. This
> very definitely makes the tests run way faster. I
> wonder if the Makefiles you are using are not setting
> this option by default on windows but are on linux?
On windows this
Update to version version 3.3.17 has solved the problem.
The issue existed in version 3.3.14
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
[EMAIL PROTECTED] wrote:
When testing, it is my usual practice to compile with
-DSQLITE_NO_SYNC=1 which turns off disk syncing. This
very definitely makes the tests run way faster. I
wonder if the Makefiles you are using are not setting
this option by default on windows but are on linux?
"Yuriy Martsynovskyy" <[EMAIL PROTECTED]> wrote:
> When I execute the SQL code below on a newly created DB file I get an
> error 'table Tab already exists', and it creates a table
>
> -- comment
> CREATE TABLE Tab(ID);
>
> Code below works without error messages:
>
> CREATE TABLE Tab(ID);
>
I
Dennis Cote <[EMAIL PROTECTED]> wrote:
>
> Do you, or anyone else, know why the linux version would not be
> committing its changes to disk?
>
When testing, it is my usual practice to compile with
-DSQLITE_NO_SYNC=1 which turns off disk syncing. This
very definitely makes the tests run way
[EMAIL PROTECTED] wrote:
I think that was fixed by check-in [3868].
Richard,
It seems you were right again. :-)
I'm not sure what caused my build to have a problem, but after building
and running the test suite on Linux with no problems, I rebooted into
Windows.
I did a make clean and
When I execute the SQL code below on a newly created DB file I get an
error 'table Tab already exists', and it creates a table
-- comment
CREATE TABLE Tab(ID);
Code below works without error messages:
CREATE TABLE Tab(ID);
Hi!
I have been reading through the mailing list and found this post in
which someone had the same problem as i had (message 15355 I think,
posted by drh), where I don't want the autoincrement column to
autoincrement when INSERT or IGNORE is forced to ignore the insert.
I tried the replace
John Elrick wrote:
John Stanton wrote:
John Elrick wrote:
John Stanton wrote:
I would look at the disk controller/disk drive hardware and the
software driver to see if they are reporting correctly to the OS.
Some of your numbers are too fast for regular disk technology and
suggest
John Stanton wrote:
John Elrick wrote:
John Stanton wrote:
I would look at the disk controller/disk drive hardware and the
software driver to see if they are reporting correctly to the OS.
Some of your numbers are too fast for regular disk technology and
suggest that there are either
John Elrick wrote:
John Stanton wrote:
The real time with the pragma off is 1.78 seconds. The real time on
the "faster" machine is 8.4 seconds. When I set the synchronous
pragma to off on the "faster" machine, the time drops to 1.64.
John
Do your various machines use the same hard disk
John Stanton wrote:
The real time with the pragma off is 1.78 seconds. The real time on
the "faster" machine is 8.4 seconds. When I set the synchronous
pragma to off on the "faster" machine, the time drops to 1.64.
John
Do your various machines use the same hard disk controller and
John Elrick wrote:
John Elrick wrote:
John Elrick wrote:
Griggs, Donald wrote:
John Elrick wrote:
"what the heck is happening that is creating a better than order of
magnitude difference in execution time on five out of seven Windows
machines?".
John,
If the database is
Please provide the processed source package, as it has been the case
for SQLite before.
"The Amalgamation" big c file (plus header file) might be an
(optional) neat package, but the standard processed source package
shall be still available.
The http://www.sqlite.org/sqlite-source-3_3_17.zip
In general, I agree. I miss the zipped set of pre-processed C source.
Since you have the Linux-based build system at your disposal, you can get what
you're used to having with
make target_source
on the Linux system. This creates a tsrc directory containing the familiar
pre-processed C
The last time I downloaded SQLite was version 3.3.12.
For that version (and many prior versions), I could download a
preprocessed archive containing all of the source code, except parse.h,
parse.c and opcode.h(? - this is from memory) were the 'generated'
versions.
The source for the command-line
16 matches
Mail list logo
