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 <[email protected]> To: [email protected] 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 <[email protected] >><mailto:[email protected]>> 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 >> <[email protected] <mailto:[email protected]>> 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, <[email protected] >> <mailto:[email protected]>> 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 >> [email protected] <mailto:[email protected]> >> +1 970.462.7450 >> >> >> Sam Tresler >> 646-246-8403 >> >> >> >> >> -- Randy Fay >> Drupal Module and Site Development >> [email protected] <mailto:[email protected]> >> +1 970.462.7450 >> > Sam Tresler 646-246-8403
