On Jan 23, 2006, at 1:55 PM, Michael Bayer wrote:
So they are adding some
overhead to the commit, but not a lot. They are definitely not being
manifest as any additional SQL or anything like that.
hi mike,
thanks as always for the response.
i do understand (and see) that the actual sql
sent to the backend does not incur any additional
overhead from the current behavior - and i do
appreciate that in general the backend costs
will dominate.
Also, Im not sure why you are doing objectstore.commit() within a loop
like that, why not do the commit after your loop has finished (thats
how
it was meant to be used) ?
i originally had it after the loop -
the current form was just a debugging
step for the previous issues that i
encountered - nevertheless, the task
dump (thanks for that feature, by the
way - it shows the nesting structure
much better than the primitive prints
that i was inserting) caused me some
concern.
one use-case that comes to mind for
which this might be an issue is for
a long-running server task, where one
subtask might be to do periodic data
importing/exporting. i can batch each
import session, but if succeeding calls
incurs the overhead from all preceding
calls, that might be a bit much. this
might lead me to externalizing the
subtask to say a cron job, but that
could impact integration.
also curious why you have a separate step for
generating primary keys, since that behavior is built-in via sequences
or
"defaults".
hmm; i was having some issues with that
before, but you're right, it seems to
work without. i'm not sure what the
original problem was anymore.
thanks again,
d
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
