Jeff,<div><br></div><div>This is likely because of all the tables that the Field SQL storage module creates (2 tables for every field). You may be interested in checking into the Per-Bundle Storage module (<a href="http://drupal.org/project/pbs">http://drupal.org/project/pbs</a>).</div>
<div><br clear="all">Dave Reid<br><a href="mailto:dave@davereid.net">dave@davereid.net</a><br>
<br><br><div class="gmail_quote">On Mon, Dec 6, 2010 at 2:08 PM, <span dir="ltr"><<a href="mailto:jeff@ayendesigns.com">jeff@ayendesigns.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div style="direction:ltr" text="#000000" bgcolor="#ffffff">
<p style="margin-bottom:0cm;margin-top:0pt">Don't get me wrong, I'm
chuffed to mint balls about the D7 effort and the result, for many
reasons, not least of which is the amazing talent represented by it.</p>
<p style="margin-bottom:0cm;margin-top:0pt"><br>
</p>
<p style="margin-bottom:0cm;margin-top:0pt">That said, I received a
letter
today from the hoster stating that my account was a performance problem
because it had over 1000 tables. Eight Drupal sites coud be over 1000
tables. </p>
<p style="margin-bottom:0cm;margin-top:0pt"><br>
I have a hosting account with 'unlimited domains' and up to 25
databases. I use the account both for hosting several live domains,
most multi site, as well as a test area that clients can access for
testing changes to existing domains. 8 Drupal sites could be over 1000
tables with the typical array of add-on modules, let alone that most of
these sites are doing e-commerce.</p>
<p style="margin-bottom:0cm;margin-top:0pt"><br>
</p>
<p style="margin-bottom:0cm;margin-top:0pt">I've let them know that
they might want to consider a more meaningful indicator of performance
issues than a script that counts tables, since probably none of these
sites does more than 100 transactions per day. If they hold firm, I'll
blog (and post here) their name.<br>
</p>
<p style="margin-bottom:0cm;margin-top:0pt"><br>
</p>
<p style="margin-bottom:0cm;margin-top:0pt">Jeff<br>
</p>
<div>-- <br>
<p style="margin-bottom:0in"><img src="cid:part1.06090000.07040401@ayendesigns.com" name="ayenlogo" valign="top" vspace="30" align="LEFT" border="0"><font style="font-size:8pt" size="1">Ayen Designs </font><font face="Times New Roman, serif"><font style="font-size:8pt" size="1">
<br>
388 Bullsboro Drive #105 · Newnan, Georgia 30263</font></font>
<br>
<font face="Times New Roman, serif"><font style="font-size:8pt" size="1">404-271-9734<br>
Web:<a href="http://ayendesigns.com" target="_blank">ayendesigns.com</a><br>
Blog: <a href="http://theaccidentalcoder.com" target="_blank">theAccidentalCoder.com</a><br>
Drupal: <a href="http://drupal.org/user/367108" target="_blank">j. ayen green</a><br>
IRQ: j_ayen_green<br>
IM (Yahoo) baalwww (MSN) <a href="mailto:baalwww@yahoo.com" target="_blank">baalwww@yahoo.com</a><br>
Skype: ayendesigns
<br>
<br>
Ayen Designs is a tradename of the computer services division of <img src="cid:part2.05090702.03050601@ayendesigns.com" name="acmelogo" align="absmiddle"></font></font></p>
</div>
</div>
</blockquote></div><br></div>