I tried the pragma synchronous=off. It has no significant effect on db on an nfs mounted file system, but does improve access to a db on a local file system. I still would like to compare the pragma to the asynchronous i/o module, if the latter is still supported.
-----Original Message----- From: D. Richard Hipp [mailto:d...@hwaci.com] Sent: Thursday, June 18, 2009 9:25 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Asynchronous I/O Module For SQLite On Jun 18, 2009, at 9:15 AM, Rizzuto, Raymond wrote: > I'm actually memory limited, which is why I am looking at moving > infrequently needed object to persistent store with sqlite3. I like > the idea of using the asynchronous i/o module so that the writing > can be done in a background thread, but still allow the main thread > to retrieve data that has been written or is in queue to be written. You do not need the async I/O package for this. Simply set "PRAGMA synchronous=OFF" and it will behave as you desire (assuming your operating system implements a filesystem cache). > > > My main questions are about that module. I am a bit confused about > it since it is not distributed in the main amalgamations. I wanted > to make sure that I can just pull the 2 files from the source > tarball, or if there are other files I would also need. > > Additionally, since asynchronous i/o seems to sit apart from the > main sqlite3, I was wondering if it would be possible to use with an > older (3.5.9) version of sqlite3 that we already use in house. D. Richard Hipp d...@hwaci.com IMPORTANT: The information contained in this email and/or its attachments is confidential. If you are not the intended recipient, please notify the sender immediately by reply and immediately delete this message and all its attachments. Any review, use, reproduction, disclosure or dissemination of this message or any attachment by an unintended recipient is strictly prohibited. Neither this message nor any attachment is intended as or should be construed as an offer, solicitation or recommendation to buy or sell any security or other financial instrument. Neither the sender, his or her employer nor any of their respective affiliates makes any warranties as to the completeness or accuracy of any of the information contained herein or that this message or any of its attachments is free of viruses. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
