sqlobject-discuss

[SQLObject] SQLObject and Multiprocessing

[Gert B. <ger...@gm...>]

Hi

Can one use SQLObject with multiprocessing? For example can one create
extra processes using the multiprocessing.Process using the 'inherited'
sqlobject environment to handle certain database queries?

Regards
Gert Burger

Re: [SQLObject] SQLObject and Multiprocessing

[Oleg B. <ph...@ph...>]

On Wed, Jun 01, 2011 at 10:39:42AM +0200, Gert Burger wrote:
> Can one use SQLObject with multiprocessing? For example can one create
> extra processes using the multiprocessing.Process using the 'inherited'
> sqlobject environment to handle certain database queries?

   I doubt it's possible to share an open connection between processes.
In a different process you are to open a different connection and that
would lead to problems with transactions. Perhaps its possible to open a
different connection and run transaction-less queries.

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.