The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

<!--  Presentation generated by Internet Assistant for Microsoft PowerPoint 97 -->

<HTML>
<HEAD>

<meta name="GENERATOR" content="Microsoft Internet Assistant for Microsoft PowerPoint 97">
 <TITLE>Web DBI - Too many connections</TITLE> 
</HEAD>

<BODY     >

<CENTER>
<TABLE WIDTH=100%> 
     <TR> <TD WIDTH=100% ALIGN=CENTER>
         <A HREF="sld001.htm">First</A>&nbsp;&nbsp;
         <A HREF="sld070.htm">Previous</A>&nbsp;&nbsp;
         <A HREF="sld072.htm">Next</A>&nbsp;&nbsp;
         <A HREF="sld102.htm">Last</A>&nbsp;&nbsp;
&nbsp;&nbsp;         <A HREF="index.htm">Index</A>&nbsp;&nbsp;
         <A HREF="dbi.perl.org">Home</A>&nbsp;&nbsp;
         <A HREF="tsld071.htm">Text</A>&nbsp;&nbsp;
     </TD> </TR>
     <TR> <TD WIDTH=100% ALIGN=CENTER>
         <IMG SRC="img071.gif" usemap="#Objmap" WIDTH=800 HEIGHT=600 BORDER=0>
     </TD> </TR>
</TABLE>
<P>Slide 71 of 102</P>
</CENTER>
<!-- <UL>
<H2>Web DBI - Too many connections</H2>
</UL></P>
<P><UL>
<LI><H2>Busy web sites run many web server processes
</H2>
<UL>
<LI>possibly on many machines...
<LI>Machines * Processes = Many Connections
<LI>Machines * Processes * Users = Very Many Connections
<LI>
</UL></UL><UL>
<LI><H2>Limits on database connections
</H2>
<UL>
<LI>Memory consumption of web server processes
<LI>Database server resources (memory, threads etc.) or licensing
<LI>
</UL></UL><UL>
<LI><H2>So… partition web servers into General and Database groups
</H2>
<UL>
<LI>
</UL></UL><UL>
<LI><H2>Direct requests that require database access to the Database web servers
</H2>
<UL>
<LI>Use Reverse Proxy / Redirect / Rewrite to achieve this
<LI>Allows each subset of servers to be tuned to best fit workload
<LI>And/or be run on appropriate hardware platforms
</UL></UL><UL>
<H2>.</H2>
</UL></P>
<P>  -->
</Body>
</HTML>