On Nov 30, 2007 2:17 PM, Mike Cantelon &lt;<a href="mailto:m_cantelon@straight.com">m_cantelon@straight.com</a>&gt; wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">



  

<div bgcolor="#ffffff" text="#000000"><div class="Ih2E3d">
Khalid Baheyeldin wrote:
<blockquote type="cite">(Changing the subject)<br>
  <br>
I regularly see 80+ to 110+, and that causes Apache to eat 100MB per
process, which is really not good ...<br>
  <br>
This is the open buffet binge syndrome detailed here:<br>
  <br>
  <a href="http://2bits.com/articles/server-indigestion-the-drupal-contributed-modules-open-buffet-binge-syndrome.html" target="_blank">http://2bits.com/articles/server-indigestion-the-drupal-contributed-modules-open-buffet-binge-syndrome.html
</a><br>
</blockquote></div>
Great article... Has anyone figured out what parts of the module
architecture are most expensive memory-wise so they can be examined?<br>
</div>

</blockquote></div><br>Yes.<br><br>a) The include_once() part is the most expensive. That is common for all modules, and the more you have the more you suffer (but there are solutions). <br>b) Creating large associative arrays (
e.g. the way we handled URL aliases before 4.7).<br>c) Doing a lot of things over the network (e.g. subscriptions module and Google Sitemap module with certain settings. One emails people, the other pings Google).<br>d) Lack of an op-code cache/accelerator.
<br>e) Excessive SQL queries, either number of queries or heavy ones. (Just saw a site with 11,400 queries per page. Ended up being badly written PHP code pasted in a block that loads on every page).<br><br>For a) I am writing an article with more details on the include_once part over the weekend (if not sooner). 
<br><br>For c) and d) there is an article or two on 2bits, one with the exact settings that causes slowness.<br>-- <br>Khalid M. Baheyeldin<br><a href="http://2bits.com">2bits.com</a><br><a href="http://2bits.com">http://2bits.com
</a><br>Drupal optimization, development, customization and consulting.