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 wrote: > database = the physical file itself > database connection = a specific reference to the database, obtained > using sqlite3_open > > page

Re: [sqlite] PRAGMA scope

; [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 mentions > that >

Re: [sqlite] PRAGMA scope

e' Subject: [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&

[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 after