<br><div class="gmail_quote">On Wed, Apr 30, 2008 at 5:52 PM, Joshua D. Drake <<a href="mailto:jd@commandprompt.com">jd@commandprompt.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">Moshe Weitzman wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
You really have to look into devel.module as Larry suggested. It<br>
starts a timer before the query initiates and stops after it completes<br>
so it is certainly round trip. Your strong assertions are not based in<br>
facts. There is no way to shave off 5 seconds because drupal pages<br>
don't take that long unless you are doing extremely non standard<br>
stuff.<br>
</blockquote>
<br></div>
*sigh*<br>
<br>
I am done here. Thanks guys!<br><font color="#888888">
<br>
Joshua D. Drake<br>
</font></blockquote></div><br><br clear="all">Joshua<br><br>I am not sure why you are "done here".<br><br>Typical page loads for a Drupal site should be under 800 ms or so. Ideally, they would <br>be from 200 ms to 500 ms. That includes database time and page generation time as <br>
well.<br><br>If you measure database time using the devel module in Drupal (as has been pointed<br>to you earlier), you will see that 200 queries will take a 100 to 300 ms out of the<br>500 ms or so total page time.<br><br>
So your math is flawed (200 queries * 30 ms each = 5000 ms) and is not a common <br>case at all. Perhaps to a specific application that you have, using PostgreSQL remotely, <br>or some other special case.<br><br>I can certainly say that the vast majority of Drupal sites on MySQL enjoy a page execution <br>
time of 800 ms or less, and well tuned sites are in the 200 - 300 ms range. If page loads<br>for Drupal or any other web application is in the 5000 ms range, no one would be using<br>it at all.<br>-- <br>Khalid M. Baheyeldin<br>
<a href="http://2bits.com">2bits.com</a>, Inc.<br><a href="http://2bits.com">http://2bits.com</a><br>Drupal optimization, development, customization and consulting.