Re: [sqlite] SQLite version 3.6.14

2009-05-08 Thread Mark Spiegel
Original Message- >> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >> boun...@sqlite.org] On Behalf Of Christian Smith >> Sent: Friday, May 08, 2009 7:24 AM >> To: General Discussion of SQLite Database >> Subject: Re: [sqlite] SQLite version 3.6.14 >&

Re: [sqlite] SQLite version 3.6.14

2009-05-08 Thread Doug
> boun...@sqlite.org] On Behalf Of Christian Smith > Sent: Friday, May 08, 2009 7:24 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] SQLite version 3.6.14 > > On Fri, May 08, 2009 at 05:32:45PM +0700, Dan wrote: > > > > On May 8, 2009, at 5:21 PM,

Re: [sqlite] SQLite version 3.6.14

2009-05-08 Thread Jim Wilcoxson
May I suggest an extension PRAGMA SYNCHRONOUS = 3 | ASYNC so that non-C bindings can use the async functionality? Thanks, this is a great enhancement! Jim >> On Wed, May 06, 2009 at 10:36:50PM -0400, D. Richard Hipp wrote: >>> >>> A new optional extension is included that implements an >>> asynch

Re: [sqlite] SQLite version 3.6.14

2009-05-08 Thread Christian Smith
On Fri, May 08, 2009 at 05:32:45PM +0700, Dan wrote: > > On May 8, 2009, at 5:21 PM, Christian Smith wrote: > > > On Wed, May 06, 2009 at 10:36:50PM -0400, D. Richard Hipp wrote: > >> > >> A new optional extension is included that implements an > >> asynchronous I/ > >> O backend for SQLite on

Re: [sqlite] SQLite version 3.6.14

2009-05-08 Thread Dan
On May 8, 2009, at 5:21 PM, Christian Smith wrote: > On Wed, May 06, 2009 at 10:36:50PM -0400, D. Richard Hipp wrote: >> >> A new optional extension is included that implements an >> asynchronous I/ >> O backend for SQLite on either windows or unix. The asynchronous I/O >> backend processes al

Re: [sqlite] SQLite version 3.6.14

2009-05-08 Thread Christian Smith
On Wed, May 06, 2009 at 10:36:50PM -0400, D. Richard Hipp wrote: > > A new optional extension is included that implements an asynchronous I/ > O backend for SQLite on either windows or unix. The asynchronous I/O > backend processes all writes using a background thread. This gives > the appea

Re: [sqlite] SQLite version 3.6.14

2009-05-07 Thread Andreas Radke
Am Wed, 6 May 2009 22:36:50 -0400 schrieb "D. Richard Hipp" : > SQLite version 3.6.14 is now available on the SQLite website > > http://www.sqlite.org/ > > Version 3.6.14 contains performance enhances in the btree and pager > subsystems. In addition, the query optimizer now knows how to

Re: [sqlite] SQLite version 3.6.14 and async vfs

2009-05-07 Thread Ken
in wrote: > From: Virgilio Alexandre Fornazin > Subject: RE: [sqlite] SQLite version 3.6.14 and async vfs > To: kennethinbox-sql...@yahoo.com, "'General Discussion of SQLite Database'" > , "'Pavel Ivanov'" > Date: Thursday, May 7, 2009, 12

Re: [sqlite] SQLite version 3.6.14 and async vfs

2009-05-07 Thread Virgilio Alexandre Fornazin
implementations. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ken Sent: quinta-feira, 7 de maio de 2009 13:47 To: General Discussion of SQLite Database; Pavel Ivanov Subject: Re: [sqlite] SQLite version 3.6.14 and async vfs I see the

Re: [sqlite] SQLite version 3.6.14 and async vfs

2009-05-07 Thread Pavel Ivanov
According to the fact that queue in async vfs is one for all databases and along with closing of one database there could be some writings to another ones, method of catching the return from sqlite3async_run() can be significantly delayed if work at all... Ok, thank you for the extension anyway. I

Re: [sqlite] SQLite version 3.6.14 and async vfs

2009-05-07 Thread Dan
On May 7, 2009, at 10:33 PM, Pavel Ivanov wrote: > Hi! > > It's great to hear about performance improvements and especially about > asynchronous I/O extension. Thank you very much for your work! > > I have one question though: taking quick look at the sources of async > vfs I've noticed that even

Re: [sqlite] SQLite version 3.6.14 and async vfs

2009-05-07 Thread Ken
n Thu, 5/7/09, Pavel Ivanov wrote: > From: Pavel Ivanov > Subject: Re: [sqlite] SQLite version 3.6.14 and async vfs > To: kennethinbox-sql...@yahoo.com, "General Discussion of SQLite Database" > > Date: Thursday, May 7, 2009, 11:10 AM > Shutdown is not an option at al

Re: [sqlite] SQLite version 3.6.14 and async vfs

2009-05-07 Thread Pavel Ivanov
gt; wrote: > >> From: Virgilio Alexandre Fornazin >> Subject: Re: [sqlite] SQLite version 3.6.14 and async vfs >> To: "'General Discussion of SQLite Database'" >> Date: Thursday, May 7, 2009, 10:50 AM >> Close should wait for all file >>

Re: [sqlite] SQLite version 3.6.14 and async vfs

2009-05-07 Thread Ken
--- On Thu, 5/7/09, Virgilio Alexandre Fornazin wrote: > From: Virgilio Alexandre Fornazin > Subject: Re: [sqlite] SQLite version 3.6.14 and async vfs > To: "'General Discussion of SQLite Database'" > Date: Thursday, May 7, 2009, 10:50 AM > Close sh

Re: [sqlite] SQLite version 3.6.14 and async vfs

2009-05-07 Thread Virgilio Alexandre Fornazin
-feira, 7 de maio de 2009 12:33 To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite version 3.6.14 and async vfs Hi! It's great to hear about performance improvements and especially about asynchronous I/O extension. Thank you very much for your work! I have one question t

Re: [sqlite] SQLite version 3.6.14 and async vfs

2009-05-07 Thread Pavel Ivanov
Hi! It's great to hear about performance improvements and especially about asynchronous I/O extension. Thank you very much for your work! I have one question though: taking quick look at the sources of async vfs I've noticed that even closing the file is just a task in the async queue and thus af

Re: [sqlite] SQLite version 3.6.14

2009-05-07 Thread Lukas Gebauer
> A new optional extension is included that implements an asynchronous > I/ O backend for SQLite on either windows or unix. The asynchronous > I/O backend processes all writes using a background thread. This > gives the appearance of faster response time at the cost of > durability and additio

Re: [sqlite] SQLite version 3.6.14

2009-05-07 Thread Alexey Pechnikov
Hello! On Thursday 07 May 2009 06:36:50 D. Richard Hipp wrote: > See http://www.sqlite.org/asyncvfs.html for > additional information. Can you add some diagramms of async I/O database usage? And usage scenarios may be very useful. Now I'm don't undertand when can applications to get help from t

Re: [sqlite] SQLite version 3.6.14

2009-05-07 Thread Jules Colding
On 07/05/2009, at 04.36, D. Richard Hipp wrote: > SQLite version 3.6.14 is now available on the SQLite website > > http://www.sqlite.org/ > > Version 3.6.14 contains performance enhances in the btree and pager > subsystems. In addition, the query optimizer now knows how to take > advantage o

Re: [sqlite] SQLite version 3.6.14

2009-05-06 Thread Cory Nelson
On Wed, May 6, 2009 at 7:36 PM, D. Richard Hipp wrote: > SQLite version 3.6.14 is now available on the SQLite website > >     http://www.sqlite.org/ > > Version 3.6.14 contains performance enhances in the btree and pager > subsystems.  In addition, the query optimizer now knows how to take > advan

[sqlite] SQLite version 3.6.14

2009-05-06 Thread D. Richard Hipp
SQLite version 3.6.14 is now available on the SQLite website http://www.sqlite.org/ Version 3.6.14 contains performance enhances in the btree and pager subsystems. In addition, the query optimizer now knows how to take advantage of OR and IN operators on columns of a virtual table. A n