Re: [sqlite] PRAGMA scope

, 2009 2:37 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] PRAGMA scope On Tue, Oct 20, 2009 at 1:33 PM, John Crenshaw <johncrens...@priacta.com> wrote: > database = the physical file itself > database connection = a specific reference to the database, obta

Re: [sqlite] PRAGMA scope

ers-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Doug > Sent: Tuesday, October 20, 2009 2:28 PM > To: 'General Discussion of SQLite Database' > Subject: [sqlite] PRAGMA scope > > I'm reading about the different PRAGMA operations. Cache_size mention

Re: [sqlite] PRAGMA scope

: [sqlite] PRAGMA scope I'm reading about the different PRAGMA operations. Cache_size mentions that it is per-database connection. Page_size says it is per database (must be used before the database is created), which sounds like per-connection (ie if I create two databases, I'm guessing I need

[sqlite] PRAGMA scope

I'm reading about the different PRAGMA operations. Cache_size mentions that it is per-database connection. Page_size says it is per database (must be used before the database is created), which sounds like per-connection (ie if I create two databases, I'm guessing I need to set the page_size