Re: [SQLObject] SQLObject mass insertion

[Juan M. S. <vic...@gm...>]

Got it, thanks

One last thing and maybe a bit offtopic: 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?

Thanks again,

Juan Manuel

From: Oleg Broytman <ph...@ph...>
To: sql...@li...
Date: Thursday 01 April 2010
> On Thu, Apr 01, 2010 at 06:18:35AM -0300, Juan Manuel Santos wrote:
> >  1/Query   :  CREATE TABLE meta_dir (
> >  [...]
> >  1/QueryR  :  CREATE TABLE meta_dir (
> >  [...]
> > 
> > Any idea why debug gets printed twice, but the second time with a capital
> > 'r' after "Query"? :P
> > 
> > Two debugging output are from
> > 
> > > different methods.
> 
> $ grep -F printDebug sqlobject/dbconnection.py
> 
>     def _executeRetry(self, conn, cursor, query):
>         if self.debug:
>             self.printDebug(conn, query, 'QueryR')
>         return cursor.execute(query)
> 
>     def _query(self, conn, s):
>         if self.debug:
>             self.printDebug(conn, s, 'Query')
>         self._executeRetry(conn, conn.cursor(), s)
> 
>     def _queryAll(self, conn, s):
>         if self.debug:
>             self.printDebug(conn, s, 'QueryAll')
> [skip]
>         if self.debugOutput:
>             self.printDebug(conn, value, 'QueryAll', 'result')
> 
>    ._query(), ._executeRetry(), etc can be called from different methods in
> a different order so these extra debugging allows to trace the call stack.
> 
> Oleg.