Hi All.

I'm working on quite big database. It consists of about 200 tables. Additionaly about 50 tables are per year (because of annual data). It means every year new 50 tables will have to appear in application. And now I have a question. Should I use separate databases for "annual" data (i.e. db2006, db2007, etc...) (i don't need constraints on that (annual) tables) or put all the tables in one database? Is there any way to 'catalogue'/organize tables within one database (namespace/schema)?
Any thoughts?
Thanks in advance...

--
_/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/
Przemek Klein ([EMAIL PROTECTED])


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to