FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Lots of Tables





polly-gone
I am currently working on a project that is EXTREMELY complicated and I find that I am using one database for all of its aspects. Would it decrease my project's efficiency at retrieving information is I split all the tables up among multiple databases?

Thanks,

-Nick Smile Smile Smile
Fire Boar
Yes. One database should be all you need, and more will really mess things up if, for example, you'd port over to a different databasing system. Keep it all together, really.

Just how complicated are we talking? Are you sure the approach you're taking is using the minimum number of tables possible while being fully normalized?
kv
multiple databases in the same project have several issues:

multiple connections in the same page
multiple queries need to be done and data needs to be synced in your code
referential integrity issues
joins not possible across dbs
cannot run sqls on db directly (for eg: to see the output, copy some data from one table to onother, etc)
which spans more than one db

As for as multiple tables concerned, it just depends on how many you use in one query. not really on how many you have in one database. I have 9 drupal installations (around 500 tables) in one db and works fine without any issues.
Related topics
*OFFICIAL* Which Browser do you use?
Lots Of Funny Pictures
CSS OR TABLES
How To : Improve Your PHP Programming
I cant install php chat tables nor set up diffrent subdomain
Site Nav Suggestions...
Microsoft Access 2003
your favorite song
Why You Should Never Use Flash
Top 10 web design mistakes!..
How can i flush my tables
HTML tables with irregular rows and/or columns
Why don't people like tables?
How to combine lots of queries to one - MySQL
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.