On Mon, Apr 20, 2009 at 11:07 PM, julian qian <julian.q...@gmail.com> wrote: > HI, > call PRAGMA page_size =xxx twice immediately, only first time it has > effect, immediately call it second times, the value can't be changed. > is this predefined? http://www.sqlite.org/pragma.html#pragma_page_size > only say "The page_size pragma will only cause an immediate change in > the page size if it is issued while the database is still empty, prior > to the first CREATE TABLE statement" >
[12:58 PM] ~/Projects/model_example/results$sqlite3 foo.db SQLite version 3.6.11 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> pragma page_size; 1024 sqlite> pragma page_size = 2048; sqlite> pragma page_size; 2048 sqlite> pragma page_size = 4096; sqlite> pragma page_size; 4096 sqlite> -- Puneet Kishor http://www.punkish.org/ Carbon Model http://carbonmodel.org/ Charter Member, Open Source Geospatial Foundation http://www.osgeo.org/ Science Commons Fellow, Geospatial Data http://sciencecommons.org Nelson Institute, UW-Madison http://www.nelson.wisc.edu/ ----------------------------------------------------------------------- collaborate, communicate, compete ======================================================================= Sent from Madison, WI, United States _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
