Hi, - I wish to have a pool of, for example, 10 connections. When a thread needs a connection it tries to get one and i wish it to block until a connection is available. However, i prefer to do this by sqlalchemy indication and not my own counter so i will actually know how many connections i have.
- I am trying to find a solution for long transactions. When i open a connection with postgresql, every connection is 35mb? pretty big. If i will hold a transaction open when i am trying to get futher information from the client it will hold block all the other waiting threads. What are my options? I understand there is some kind of unitofwork such that perhaps, i run the queries i have so far on the transaction and if all pass i release the transaction and connection but keep the unitofwork. Then, when the client communicates more information for the transaction i append the unitofwork and replay the transaction with the new queries. How do i do that? -- Regards, Tzahi. -- Tzahi Fadida Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info WARNING TO SPAMMERS: see at http://members.lycos.co.uk/my2nis/spamwarning.html ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
