Hi! This is my first advice for twisted-python list I hope I get this right.<br><br>I don't know much about adbapi but you might to check if your database is causing the bottleneck. Also, what reactor are you using? You might want to configure your twisted application to use the epoll reactor. We have a server here using epoll and believe me this thing is wonderful. ^_^
<br><br><br><div><span class="gmail_quote">On 6/13/07, <b class="gmail_sendername">weiwei weiwei</b> <<a href="mailto:waterinfire@hotmail.com">waterinfire@hotmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,all!<br><br><br><br> Thanks for the python twisted,it is a great software.<br><br><br><br> I am from china. This days we use twisted to develop a middleware.<br><br><br><br> Requirement is:<br><br>
1) Receive: receive 100~200 different clientĄ¯s message(they all<br>connect to our listen socket) and insert it into database(oracle)<br><br>2) Send: application insert message into db,then our middleware select
<br>message from database and send this message to its destination through<br>socket.<br><br><br><br>Our design is : reactor + adbapi.ConnectionPool<br><br>1) reactor is used in receiveing and sending message from and to
<br>socket.<br><br>2) when we received a message,we use adbapi to insert it to db<br><br>3) we use adbapi to select message from db,and use a Deferred to<br>notify us when we got a message from db,and send it to peer,after receiving
<br>the peerĄ¯s acknowledge message ,we update the databse.<br><br><br><br>After testing many times,we found when the connection number is less than<br>20,its performance is very good.But if the connection number is more than 30
<br>or 50, it is performance is worse and worse.<br><br><br><br>DO you give me some advice about the design?<br><br><br><br><br><br>Thanks in advance.<br><br><br><br><br><br>Wei wei<br><br>_________________________________________________________________
<br>Express yourself instantly with MSN Messenger! Download today it's FREE!<br><a href="http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/">http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
</a><br><br><br>_______________________________________________<br>Twisted-Python mailing list<br><a href="mailto:Twisted-Python@twistedmatrix.com">Twisted-Python@twistedmatrix.com</a><br><a href="http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python">
http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python</a><br></blockquote></div><br>