<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:12pt"><DIV></DIV>
<DIV>Sam, I have a tendency to agree with you on the number of tables. I've kind of gotten used to it, but I sued to look at the database and say, "OMG, 125 tables?" That's one of the drawbacks to normalizing. The idea is that it allegedly ends up decreasing the count, I find that, in practice, it usually does not. In the olden days, before databases (now called NoSql), one could create a file with many different record layouts in it and still understand what one was working with. Just think of it as DBA job security.<BR> </DIV>
<P><FONT face="bookman old style, new york, times, serif" color=#ff007f size=4><EM><STRONG>Nancy</STRONG></EM></FONT></P>
<P> </P>
<P><FONT face="arial, helvetica, sans-serif">Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.</FONT></P>
<DIV><BR></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: arial, helvetica, sans-serif"><BR>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><FONT face=Tahoma size=2>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Sam Tresler <sam@treslerdesigns.com><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> development@drupal.org<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Tue, December 7, 2010 10:24:19 AM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [development] D7 side effect<BR></FONT><BR>I stand corrected, that must have changed with D7. However, I think you and I have different interpretations of the word 'only' ;) Thanks.<BR><BR>Regards,<BR> Sam Tresler<BR><BR>On Mon, 6 Dec 2010, Jamie Holly wrote:<BR><BR>> A base install of D7 only has 75 tables.<BR>> <BR>> Jamie Holly<BR>> http://www.intoxination.net<BR>> http://www.hollyit.net<BR>> <BR>> <BR>> On 12/6/2010 11:20 PM, Randy Fay wrote:<BR>>> Poll module does not create tables unless it is enabled, and if you uninstall it, it should delete them. If you don't use poll, and you
uninstall it before upgrading it, I don't think you'll see anything after upgrade.<BR>>> <BR>>> If you once had it enabled, then the update would try to update it (I think).<BR>>> <BR>>> My D7 blog (updated from D6) has 125 tables, including poll, poll_choices, and poll_votes, which is a fairly normal number for a simple D7 site.<BR>>> <BR>>> -Randy<BR>>> <BR>>> On Mon, Dec 6, 2010 at 9:02 PM, Sam Tresler <<A href="mailto:sam@treslerdesigns.com" ymailto="mailto:sam@treslerdesigns.com">sam@treslerdesigns.com</A> <mailto:<A href="mailto:sam@treslerdesigns.com" ymailto="mailto:sam@treslerdesigns.com">sam@treslerdesigns.com</A>>> wrote:<BR>>> <BR>>> Discussions about shared vs. dedicated hosting aside...<BR>>> <BR>>> Why does a default Drupal "install" create all the tables for all<BR>>> the core modules at once, as opposed to
when the modules are<BR>>> enabled? Maybe this has changed and I should go look again, but<BR>>> it seems to me that I have a lot of Drupal sites with, for example:<BR>>> <BR>>> | poll | | poll_choices | |<BR>>> poll_votes |<BR>>> <BR>>> tables that I have never once used.<BR>>> <BR>>> Is there a reason these aren't enabled on demand as opposed to on<BR>>> install?<BR>>> <BR>>> -Sam<BR>>> <BR>>> <BR>>> <BR>>> On Mon, 6 Dec 2010, Randy Fay wrote:<BR>>> <BR>>> It's my oft-stated opinion that no non-trivial site will ever<BR>>>
live happily<BR>>> for long on shared hosting. Trivial sites do fine. I have my<BR>>> D7 blog on<BR>>> Dreamhost, which has unlimited everything. But you see, it's<BR>>> not really<BR>>> unlimited, because they kill long-running processes, etc.,<BR>>> etc. So it's<BR>>> fine for a site that does not have many visitors or lots of<BR>>> modules.<BR>>> Dreamhost and some other hosts are even fine where you have<BR>>> lots and lots of<BR>>> databases or files. But it's the actual use where they get you.<BR>>> <BR>>> -Randy<BR>>>
<BR>>> On Mon, Dec 6, 2010 at 2:49 PM, Shai Gluskin<BR>>> <<A href="mailto:shai@content2zero.com" ymailto="mailto:shai@content2zero.com">shai@content2zero.com</A> <mailto:<A href="mailto:shai@content2zero.com" ymailto="mailto:shai@content2zero.com">shai@content2zero.com</A>>> wrote:<BR>>> <BR>>> Jeff,<BR>>> <BR>>> Kudos to you for finding a shared host where you can get<BR>>> decent<BR>>> performance, from your perspective, for such a set-up.<BR>>> <BR>>> I just had one bad experience after another with Drupal on<BR>>> shared hosting.<BR>>>
I finally caved and got a dedicated box with support.<BR>>> <BR>>> The amount I pay for a dedicated server is paid back to me<BR>>> many times in<BR>>> therapy bills I save.<BR>>> <BR>>> In my case, I was always yelling at the shared host for<BR>>> lousy performance<BR>>> before they would come to me complaining I'm using too<BR>>> many resources. But<BR>>> all the power to ya' if you and your clients have been happy.<BR>>> <BR>>> The host coming after you, however, is to be expected.<BR>>>
<BR>>> best,<BR>>> <BR>>> Shai<BR>>> <BR>>> On Mon, Dec 6, 2010 at 3:24 PM, <<A href="mailto:jeff@ayendesigns.com" ymailto="mailto:jeff@ayendesigns.com">jeff@ayendesigns.com</A><BR>>> <mailto:<A href="mailto:jeff@ayendesigns.com" ymailto="mailto:jeff@ayendesigns.com">jeff@ayendesigns.com</A>>> wrote:<BR>>> <BR>>> For those who don't have the few minutes: it's an<BR>>> expression of joy!<BR>>> <BR>>> <BR>>> On 12/06/2010 03:17 PM, Steve Edwards wrote:<BR>>> <BR>>> As I
side note, I just spent a few minutes<BR>>> googling the phrase "chuffed<BR>>> to mint balls", since I had never heard that<BR>>> before. Thanks for adding that<BR>>> phrase to the collective Drupal vocabulary, Jeff. :-)<BR>>> <BR>>> <BR>>> <BR>>> <BR>>> <BR>>> -- Randy Fay<BR>>> Drupal Module and Site Development<BR>>> <A href="mailto:randy@randyfay.com" ymailto="mailto:randy@randyfay.com">randy@randyfay.com</A> <mailto:<A href="mailto:randy@randyfay.com"
ymailto="mailto:randy@randyfay.com">randy@randyfay.com</A>><BR>>> +1 970.462.7450<BR>>> <BR>>> <BR>>> Sam Tresler<BR>>> 646-246-8403<BR>>> <BR>>> <BR>>> <BR>>> <BR>>> -- Randy Fay<BR>>> Drupal Module and Site Development<BR>>> <A href="mailto:randy@randyfay.com" ymailto="mailto:randy@randyfay.com">randy@randyfay.com</A> <mailto:<A href="mailto:randy@randyfay.com" ymailto="mailto:randy@randyfay.com">randy@randyfay.com</A>><BR>>> +1 970.462.7450<BR>>> <BR>> <BR><BR>Sam Tresler<BR>646-246-8403<BR><BR></DIV></DIV></div></body></html>