Re: [sqlite] Ambiguity in 'pragma page_size' docs

2017-04-12 Thread Richard Hipp
On 4/12/17, David Raymond wrote: > > When I open a connection, what's > the best way to ensure I've connected to an existing file, and am not about > to create a brand new one by trying to find out? Use sqlite3_open_v2() to create the database connection and make sure

Re: [sqlite] Ambiguity in 'pragma page_size' docs

2017-04-12 Thread David Raymond
...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Wednesday, April 12, 2017 3:53 PM To: SQLite mailing list Subject: Re: [sqlite] Ambiguity in 'pragma page_size' docs On 4/12/17, Jens Alfke <j...@mooseyard.com> wrote: > The docs[1] say that: > >> The page_size pragma will only se

Re: [sqlite] Ambiguity in 'pragma page_size' docs

2017-04-12 Thread Jens Alfke
> On Apr 12, 2017, at 12:53 PM, Richard Hipp wrote: > > The implication *should* be that you *never* change the page size. > SQLite will pick a good page size for you automatically, which works > in 99.99% of all cases. … provided you're running 3.12 or later. Prior to that it

Re: [sqlite] Ambiguity in 'pragma page_size' docs

2017-04-12 Thread Richard Hipp
On 4/12/17, Jens Alfke wrote: > The docs[1] say that: > >> The page_size pragma will only set in the page size if it is issued before >> any other SQL statements that cause I/O against the database file. > > It's not stated explicitly, but I believe the pragma has to be issued

[sqlite] Ambiguity in 'pragma page_size' docs

2017-04-12 Thread Jens Alfke
The docs[1] say that: > The page_size pragma will only set in the page size if it is issued before > any other SQL statements that cause I/O against the database file. It's not stated explicitly, but I believe the pragma has to be issued before any other statement _ever_ causes I/O, i.e. it