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
----------------------------------------------------------------
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to