Hi,

how do I set PRAGMA synchronous=OFF; via SQLObject?

I have tried doing :

 connection = connectionForURI(connection_string)
 connection.queryAll('PRAGMA synchronous=OFF;')

and this:

<tablename>.sqlmeta.createSQL = {'sqlite':['PRAGMA synchronous=OFF;','PRAGMA default_cache_size=12000000;']}

without any improvements in performance.

Before anyone complains: I dont care about loosing data. ;-)

thanks

--
Flávio Codeço Coelho
----------------------------------------------------------------
Teaching is Impossible, Learning is inevitable.
====================================
registered Linux user # 386432
get counted at http://counter.li.org
----------------------------------------------------------------