On 30 Aug 2011, at 5:03pm, Nick wrote: > On 30 Aug 2011, at 16:53, Simon Slavin wrote: > >> Most PRAGMAs, including others which modify engine behaviour like >> recursive_triggers, are not stored in the database but have to be restated >> every time you open the database file. > > Ok, thanks, If that is the case for this PRAGMA I did not realise.
I understand. It seems reasonable to me too that these settings might be preserved in the database file. > Similar to the page_count PRAGMA I would have intuitively expected > max_page_count would not need restating every time the database file is open. page_count lets the engine tell you something about the database file. max_page_count is the reverse: it lets you tell the engine something about how you want it to work from now on (until you change the setting or, as you just discovered, the connection is closed). And there's even a third kind of PRAGMA: page_size, which lets you tell SQLite something about any new databases it creates but once the database is created this setting is set and can't be changed. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
