Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
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 drinking their drinks and smoking their pipes about the Monastery: (12)
As of 2014-10-22 08:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (114 votes), past polls