--- nickg <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I'm on a Mac, OX 10.4.1, and Sqlite works great, except.... it seems
> to be defaulting to PRAGMA SYNCHRONOUS=FULL (3) instead of
> "NORMAL" (2). This is painfully slow.
> While I can send 'set pragma synchronous=normal' at every write, this
> seems strange. How do i change this at the compile/configure stage?
> I attempted look at the source code but couldn't find figure it out.
> The installation guide didn't seem to have this parameter either.
> Any clues?
>
> thanks,
>
> --nickg
>
>
I don't there exists such an option. If you're desperate to change it,
modify the value function sqlite3pager_open() sets variable pPager->fullSync
to. For "NORMAL", you want it initialized to 0.
Dan.
__________________________________
Yahoo! Mail
Stay connected, organized, and protected. Take the tour:
http://tour.mail.yahoo.com/mailtour.html
