sqlite-users@mailinglists.sqlite.org

Not an expert, but I doubt that WAL will have much of anything to do with your read performance after you've populated the database and committed the last insert transaction. WAL mostly deals with inserts (http://www.sqlite.org/draft/wal.html). Once the last transaction is written and you are onl

sqlite-users@mailinglists.sqlite.org

Roger Binns, Thank you suggesting that we run a benchmark that tests our prototype deduper with and without WAL using different page sizes and different transactions. >> You never answered the important bit - is your concern about initial >> population of the database or about runtime later

Re: [sqlite] Discussing and contributing to new System.Data.SQLite project

Hi- The SDS project is currently being maintained by the same people who maintain SQLite. We're currently also using the same mailing list (this one, sqlite-users) for discussions of SDS. Contributions are always welcome, but please note we will need a "contributor agreement" on file: http://syst

[sqlite] Discussing and contributing to new System.Data.SQLite project

Who is maintaining the new System.Data.SQLite project at http://system.data.sqlite.org? Is there a separate mailing list for that project or should questions on that project be sent to the sqlite-users this mailing list? My company is interested in knowing what the plans are going forward and mos

Re: [sqlite] .NET4 is available?

The latest versions are available at http://system.data.sqlite.org On Thu, May 26, 2011 at 11:54 AM, Massimo Savazzi wrote: > I'm using the "old": 1.0.66.1 .NET4 > > http://sqlite.phxsoftware.com/tags/.NET+4/default.aspx > > > > Do we have an updated version? > > > > > > ==

Re: [sqlite] SQLite in Xcode

Tom: Thanks for the information and I will be looking at the slideshow soon. This project was an InDesign plugin project, which, by agreement when I use the SDK, is a C++ project. I could probably fit in all of the Objective-C code you suggest, but (okay, this is a whine) the InDesign SD

Re: [sqlite] Need help constructing some simple commands

don wish wrote: > Thus, if the "Subject" column does not contain the string "last", I > want to replace the "Value" with an integer, say "5". > > Also, if the "Subject" column contains the string "current", I want > to replace the "Value" witn an integer, say "3". What should happen in the (pres

Re: [sqlite] SQLite in Xcode

On 27 May 2011, at 2:53am, BareFeetWare wrote: > The slideshow makes it pretty easy to follow: > http://www.barefeetware.com/sqlite/iosxcode/?ml You do actually show what boxes to click in Xcode which is pretty useful. Simon. ___ sqlite-users mailing

[sqlite] R*-Tree limit

Hello, I would like to use the R*-Tree for a big number of columns, let's say 50. However I read in the doc that it was limited to 11. Is there any way to remove this limit ? My goal is to sort N-dimension arrays to get all the records in a range like minX, maxX, miny, maxY ... minK maxK. Is th

Re: [sqlite] Is it possible to optimize the read performance of a C++ app using sqlite pragma journal_mode = wal & pragma wal_checkpoint?

Jean-Christophe Deschamps. Thank you for thoughtful reply. I will show it my boss when he return on Tuesday(Monday May 30th is Memorial Day. Thank you. Date: Fri, 27 May 2011 03:27:44 +0200 To: frank_chan...@hotmail.com From: j...@antichoc.net Subject: Re: [sqlite] Is it possible to optimize t

[sqlite] Need help constructing some simple commands

   To start, I am not an SQLite user. i haven't used a database for    many years and have never used an SQL database.    I am on a MS Windows system. I have an application that uses SQLite as a    database for storing its information.    The name of the file containing the database is "a.sqlite"

[sqlite] .NET4 is available?

I'm using the "old": 1.0.66.1 .NET4 http://sqlite.phxsoftware.com/tags/.NET+4/default.aspx Do we have an updated version? = STRICTLY PERSONAL AND CONFIDENTIAL This message may contain confidential and proprietary material for the sole use of the int