Hi all, glad to be back in the list :) I have a question related with a huge project, i could have these 2 schemes: 1) just one database with several tables database | tables DB_1 | user, profile, supplier, dept, etc... a lot of tables 2) several databases with few tables database | tables DB_1 | user, profile DB_2 | supplier, dept DB_etc | etc what would be the best choice ?, think that all tables contain thousands of rows, and applications have to access most of them, for example user information; even when working with suppliers users are required, so in case 2 the application must connect to both databases. any suggestions ?? thanx a lot. Carlos _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Hi all, glad to be back in the list :)I have a question related with a huge project, i could have these 2 schemes:
1) just one database with several tables
database | tables
DB_1 | user, profile, supplier, dept, etc... a lot of tables
2) several databases with few tables
database | tables
DB_1 | user, profile
DB_2 | supplier, dept
DB_etc | etc
what would be the best choice ?, think that all tables contain thousands of rows, and applications have to access most of them, for example user information; even when working with suppliers users are required, so in case 2 the application must connect to both databases.
any suggestions ??
thanx a lot.
Carlos
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
