Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

How many mySQL tables is too many? (While working with DBI)

by Anonymous Monk
on Feb 13, 2002 at 17:34 UTC ( #145219=perlquestion: print w/ replies, xml ) Need Help??
Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

I'm working on a Perl project and it currently uses about 50 different tables. Should I attempt to consolidate and lose readability and organization, or is there no efficiency hit along the Perl->DBI->mySQL pipeline?

Comment on How many mySQL tables is too many? (While working with DBI)
Re: How many mySQL tables is too many? (While working with DBI)
by perrin (Chancellor) on Feb 13, 2002 at 18:12 UTC
    There's nothing inherently wrong with having a lot of tables. If you run into problems with joins being too slow, you could look into various forms of caching, including caching in a de-normalized table. Don't do that until you actually hit performance problems though.
Re: How many mySQL tables is too many? (While working with DBI)
by screamingeagle (Curate) on Feb 13, 2002 at 18:13 UTC
      Hi, I just wanted to take a moment and thank you for your reply. I read all of those links and they were extremely helpful. It will certainly assist me in my design. Thank you!

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://145219]
Approved by root
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (11)
As of 2014-07-29 10:04 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (213 votes), past polls