Re: [sqlite] Different temp_store_directory settings okay?

nd application blow away all the temporary data for the first application sitting in /tmp? > > I am experiencing physical DB corruption and am searching > > for possible explanations. > Is the corruption repeatable? What version of SQLite are you running? No, unfortunately. 3.6.14.

[sqlite] Different temp_store_directory settings okay?

physical DB corruption and am searching for possible explanations. Brian Dantes ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Strange index creation/insertion performance between Windows and Linux 64-bit

Thanks for the replies. - All insertions are within a transaction - Database was originally created on Linux (with a 1K page size) and copied to Windows - Changing the page size to 4K (and vacuuming) lowered the index creation time on Windows to 50 seconds and on Linux to 5.5 minutes.

[sqlite] Strange index creation/insertion performance between Windows and Linux 64-bit

and the insertion speed seems fairly constant. Can anyone offer any explanations for these huge disparities in sqlite performance on these two platforms? And why Windows does badly on index insertions and well on rebuilding it from scratch, and Linux 64-bit has the exact opposite behavior? Brian

[sqlite] TOCTOU pager bug in 3.6.14.2

See Ticket 3883 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite 3.5.9 bug with journals and file locking

If a transaction is opened on a DB for which a journal file exists, and fcntl() returns EACCES or EPERM on the attempt to acquire a write lock on the DB to replay the journal, SQLite 3.5.9 quietly ignores the journal without replaying it and continues on. This is a serious bug. SQLite 3.6.14.2

[sqlite] Alignment bug in SQLIte 3.6.14.2

We've run into an alignment issue in SQLite 3.6.14.2 which only seems to cause a problem under Solaris Sparc in our testing. Failure narrowed down to: src/rowset.c:186 pEntry->v = rowid pEntry is 0xX4 __alignof(*pEntry) is 8 (because of an i64) However sizeof(RowSet) is 28 (and 28%8 = 4),