[development] D7 side effect

[nan wich]

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.
 
Nancy
 
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.




________________________________
From: Sam Tresler <sam at treslerdesigns.com>
To: development at drupal.org
Sent: Tue, December 7, 2010 10:24:19 AM
Subject: Re: [development] D7 side effect

I stand corrected, that must have changed with D7.  However, I think you and I 
have different interpretations of the word 'only'  ;)  Thanks.

Regards,
  Sam Tresler

On Mon, 6 Dec 2010, Jamie Holly wrote:

> A base install of D7 only has 75 tables.
> 
> Jamie Holly
> http://www.intoxination.net
> http://www.hollyit.net
> 
> 
> On 12/6/2010 11:20 PM, Randy Fay wrote:
>> 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.
>> 
>> If you once had it enabled, then the update would try to update it (I think).
>> 
>> 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.
>> 
>> -Randy
>> 
>> On Mon, Dec 6, 2010 at 9:02 PM, Sam Tresler <sam at treslerdesigns.com 
>><mailto:sam at treslerdesigns.com>> wrote:
>> 
>>    Discussions about shared vs. dedicated hosting aside...
>> 
>>    Why does a default Drupal "install" create all the tables for all
>>    the core modules at once, as opposed to when the modules are
>>    enabled?  Maybe this has changed and I should go look again, but
>>    it seems to me that I have a lot of Drupal sites with, for example:
>> 
>>    | poll                    | | poll_choices            | |
>>    poll_votes              |
>> 
>>    tables that I have never once used.
>> 
>>    Is there a reason these aren't enabled on demand as opposed to on
>>    install?
>> 
>>    -Sam
>> 
>> 
>> 
>>    On Mon, 6 Dec 2010, Randy Fay wrote:
>> 
>>        It's my oft-stated opinion that no non-trivial site will ever
>>        live happily
>>        for long on shared hosting. Trivial sites do fine. I have my
>>        D7 blog on
>>        Dreamhost, which has unlimited everything. But you see, it's
>>        not really
>>        unlimited, because they kill long-running processes, etc.,
>>        etc.  So it's
>>        fine for a site that does not have many visitors or lots of
>>        modules.
>>        Dreamhost and some other hosts are even fine where you have
>>        lots and lots of
>>        databases or files. But it's the actual use where they get you.
>> 
>>        -Randy
>> 
>>        On Mon, Dec 6, 2010 at 2:49 PM, Shai Gluskin
>>        <shai at content2zero.com <mailto:shai at content2zero.com>> wrote:
>> 
>>            Jeff,
>> 
>>            Kudos to you for finding a shared host where you can get
>>            decent
>>            performance, from your perspective, for such a set-up.
>> 
>>            I just had one bad experience after another with Drupal on
>>            shared hosting.
>>            I finally caved  and got a dedicated box with support.
>> 
>>            The amount I pay for a dedicated server is paid back to me
>>            many times in
>>            therapy bills I save.
>> 
>>            In my case, I was always yelling at the shared host for
>>            lousy performance
>>            before they would come to me complaining I'm using too
>>            many resources. But
>>            all the power to ya' if you and your clients have been happy.
>> 
>>            The host coming after you, however, is to be expected.
>> 
>>            best,
>> 
>>            Shai
>> 
>>            On Mon, Dec 6, 2010 at 3:24 PM, <jeff at ayendesigns.com
>>            <mailto:jeff at ayendesigns.com>> wrote:
>> 
>>                For those who don't have the few minutes: it's an
>>                expression of joy!
>> 
>> 
>>                On 12/06/2010 03:17 PM, Steve Edwards wrote:
>> 
>>                    As I side note, I just spent a few minutes
>>                    googling the phrase "chuffed
>>                    to mint balls", since I had never heard that
>>                    before.  Thanks for adding that
>>                    phrase to the collective Drupal vocabulary, Jeff. :-)
>> 
>> 
>> 
>> 
>> 
>>        --        Randy Fay
>>        Drupal Module and Site Development
>>        randy at randyfay.com <mailto:randy at randyfay.com>
>>        +1  970.462.7450
>> 
>> 
>>    Sam Tresler
>>    646-246-8403
>> 
>> 
>> 
>> 
>> -- Randy Fay
>> Drupal Module and Site Development
>> randy at randyfay.com <mailto:randy at randyfay.com>
>> +1  970.462.7450
>> 
> 

Sam Tresler
646-246-8403
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20101207/856bbbe1/attachment-0001.html