page_size must be the first statement.
PRAGMA page_size=4096;
PRAGMA default_cache_size=250000;
CREATE TABLE timestamp (date TEXT, time TEXT, script_version REAL);
INSERT INTO timestamp VALUES('27/06/07', '14:38:18', '0.01');
> sqlite3 temp.db ".read create.load"
>
> create.load is actually the first script which just contains:
>
> PRAGMA default_cache_size=250000;
> PRAGMA page_size=4096;
> CREATE TABLE timestamp (date TEXT, time TEXT, script_version REAL);
> INSERT INTO timestamp VALUES('27/06/07', '14:38:18', '0.01');
>
> The timestamp table allows me to crudely check when the extract-load
> process last ran, and it also makes sure that by the time this script
> finishes the SQLite database is in place. My problem is that of the two
> optimisation pragmas, default_cache_size appears to be working but not
> page_size. When I check the latter after the script has completed it is
> still 1024 bytes.
____________________________________________________________________________________
Food fight? Enjoy some healthy debate
in the Yahoo! Answers Food & Drink Q&A.
http://answers.yahoo.com/dir/?link=list&sid=396545367
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
