> One last thing and maybe a bit offtopic:
Offtopic for that thread, so I started a new thread on this new topic.
> how do I set "PRAGMA asyncrhonous =
> OFF" for the SQLite connection? I'm trying to see if the speed difference is
> due to this (as I suspect that SQLA uses PRAGMA), but this:
>
> self._conn.queryAll("PRAGMA synchronous=OFF;")
>
> or this:
>
> self._conn.query("PRAGMA synchronous=OFF;")
>
> Doesn't change anything. Any ideas?
I'd recommend you first to try this from the command line. Does it
really matter for a program? If there is a difference between these modes
then I can guess the problem with SQLObject not setting the asynchronous
mode is that it sets it on a different connection. _connection is not a DB
API connection but an instance of SQLObject's DBConnection that handles a
lot of low-level connections itself. Usually .query() opens a connection,
executes the query and closes the connection; or it maintains a pool of
open connections and uses a random one from the pool. So two different
queries (PRAGMA and INSERT) could be run via two different low-level
connections.
The simplest way to narrow the range of low-level connections is to open
a transaction and run all queries through the transaction. A transaction,
obviously, uses one DB API connection.
The more complex way would be to override SQLite's connection factory,
but that's a long and ugly story, though it is possible and sometimes
required in SQLObject.
Oleg.
--
Oleg Broytman http://phd.pp.ru/ p...@phd.pp.ru
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
