Hello,
I am trying to optimise an SQLite database running on Windows. One of
the things I'm looking at is page size. However, a page on sqlite.org
(http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuningWindows) mentions
this:
"Just a note that you must also perform this command [PRAGMA
page_size=4096; ] before you start a transaction (despite the
optimization hint that every command should be in a transaction)."
Is this still true? Do I need to specify page size before any INSERT or
SELECT query, even though it is already set from the moment of database
creation? If I don't, what happens?
Regards,
Martin
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------