On 05/16/2011 01:26 PM, "Cédric Krier" <[email protected]>" wrote:
> So after re-reading the psycopg2 doc [1], I could create a thread per query
> and read the result after which will allow parallelisation of the queries and
> will improve the performences.

It *might* improve performance. Don't assume it will. My guess would be
diminishing returns kick in pretty fast.

And how is spawning threads per query affected by the GIL?

http://wiki.python.org/moin/GlobalInterpreterLock


> What do you think about this API?

Like it! Though Alberto raises a valid point wrt transactions.

-- 
________________________________________________________________
Paul J Stevens        pjstevns @ gmail, twitter, skype, linkedin
NFG Net Facilities Group BV___________________________Utrecht_NL

-- 
[email protected] mailing list

Reply via email to