MySQL efficiency...

[HyperDawn]

Hey...

I was just wondering, in which situation would MySQL function more effeciently in these 2 examples:



First Example
==========

Database
+table_users1
+table_bleh1
+table_example1
+table_test1
+table_etc1
+table_users2
+table_bleh2
+table_example2
+table_test2
+table_etc2
+table_users3
+table_bleh3
+table_example3
+table_test3
+table_etc3



Second Example
========
Database1
+table_users
+table_bleh
+table_example
+table_test
+table_etc

Database2
+table_users
+table_bleh
+table_example
+table_test
+table_etc

Database3
+table_users
+table_bleh
+table_example
+table_test
+table_etc



Basically splitting the tables down into different databases... I figured the second option would be more efficient, but then I also thought it may slow it down if it has to access lots databases at once and keep changing etc... thoughts please thanks in advance

[seanf]

Moved to a more appropriate forum

Sean

[HyperDawn]

Where did I post it?

[Vexalith]

If you want to join the various tables together in any combination, then putting them all in one database is probably more efficient.

If the three sets of tables are completely separate, it's probably best to put them in separate databases - I'm not sure how much faster this would be, but I think at least a little.

[seanf]

Originally posted by HyperDawn
Where did I post it?

PHP

Sean