<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>eutechnyx</TITLE><BASE
href="file://C:\Program Files\Common Files\Microsoft Shared\Stationery\">
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META http-equiv=imagetoolbar content=no>
<STYLE type=text/css>P.msoNormal {
FONT-SIZE: 12pt; MARGIN: 0px; FONT-FAMILY: "Arial"
}
P {
FONT-SIZE: 10pt; MARGIN: 0px; COLOR: #000; FONT-FAMILY: "Arial"
}
TD {
FONT: 8pt Arial, Helvetica, sans-serif
}
TABLE {
COLOR: #666
}
A {
COLOR: #666
}
</STYLE>
<META content="MSHTML 6.00.6000.20861" name=GENERATOR></HEAD>
<BODY
style="PADDING-RIGHT: 20px; PADDING-LEFT: 20px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px"
bgColor=#ffffff>
<DIV>
<P style="MARGIN-BOTTOM: 0cm">Hello All, </P>
<P style="MARGIN-BOTTOM: 0cm">Im not sure if this is the correct list to post
this sort of thing but I have a question about python threading and the GIL. I
have a multi-threaded application that is hitting a MySQL database for some info
from within the various threads. When increase the size of my thread pool I see
little or no improvement in the application performance but the CPU usage is not
maxed. This suggests to me that the app is IO bound on the database, surly more
threads should help in this case. </P>
<P style="MARGIN-BOTTOM: 0cm"> </P>
<P style="MARGIN-BOTTOM: 0cm">Is it possible that the GIL is not being release
by a thread during the time its blocking on the DB connection? Im using MySQLdb
module and the application is purely written in python.</P>
<P style="MARGIN-BOTTOM: 0cm"> </P>
<P style="MARGIN-BOTTOM: 0cm">Thanks for any information,</P>
<P style="MARGIN-BOTTOM: 0cm"> </P>
<P style="MARGIN-BOTTOM: 0cm">Tim Kelsey</P>
<P style="MARGIN-BOTTOM: 0cm"><BR></P></DIV><p><font face="Arial" size=1>This e-mail is confidential and may be
privileged. It may be read, copied and used only by the intended recipient. No
communication sent by e-mail to or from Eutechnyx is intended to give rise to
contractual or other legal liability, apart from liability which cannot be
excluded under English law. </font></p>
<p><font face="Arial" size=1>This email has been scanned for all known viruses by the
Email Protection Agency.</p> <a href="http://www.eutechnyx.com">www.eutechnyx.com</a>
</font><font face="Arial" size=1>Eutechnyx Limited. Registered in England No:
2172322</font></p>
</BODY></HTML>