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 thi
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 a
Yes, you're right and that's a bit odd. I've set the debug variable in the
usual way:
self._conn = connectionForURI(con_str)
self._conn.debug = True
And I noticed this also:
1/Query : CREATE TABLE meta_dir (
[...]
1/QueryR : CREATE TABLE meta_dir (
[...]
Any id
On Thu, Apr 01, 2010 at 05:47:06AM -0300, Juan Manuel Santos wrote:
> http://pastebin.com/raw.php?i=Xp1TjmZ0
>
> Basically, if you look in the previous link for "Setting icon" or "Setting
> thumb" you will see that both the icon and the thumb are being set TWICE!
> with
> the same data.
The
(Sorry, little mistake on the To: field and this didn't go to the list. My
apologies for the one who received this :P)
Hi everybody again, sorry for the delay in answering.
I've been doing some more testing, with both ORMs (SQLO and SQLA) in debug
mode, and seeing the SQL that gets sent to the
On Tue, Mar 23, 2010 at 12:57:19AM -0300, Juan Manuel Santos wrote:
> Are there any ideas on why would SQLO
> be a bit slower
When you declare a table
class MyTable(SQLObject):
...columns...
and do an INSERT by calling MyTable(columns) SQLObject immediately does a
SELECT to get back autog
