Re: [sqlite] Is it possible to optimize the readperformanceof a C++ app using sqlite pragma journal_mode = wal

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Frank Chang Sent: Saturday, May 28, 2011 9:38 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is it possible to optimize the readperformanceof a C++ app using sqlite pragma

Re: [sqlite] Is it possible to optimize the readperformanceof a C++ app using sqlite pragma journal_mode = wal

Michael Stephenson, We want to thank you again for your excellent suggestions regarding how to improve the speed of our Sqlite WAL reads and our deduper prototype. We looked at the SQlite documentation for increasing the Sqlite page size to 4K and an excerpt of our code is shown below. If we

Re: [sqlite] Is it possible to optimize the readperformanceof a C++ app using sqlite pragma journal_mode = wal

On 28 May 2011, at 4:30pm, Frank Chang wrote: > We were wondering if you could tell us what sqlite C/C++ API function to use > to change the SQLIte page size to 4KB. Thank you for all of your help. Page Size is part of the setup of the database file, so the way you set it is this: Use PRAGMA

Re: [sqlite] Is it possible to optimize the readperformanceof a C++ app using sqlite pragma journal_mode = wal

Michael Stephenson, Thank you for all of your excellent ideas on increasing the speed of the deduper and the speed of the WAL reads, We will try these ideas. We were wondering if you could tell us what sqlite C/C++ API function to use to change the SQLIte page size to 4KB. Thank you for all