Re: tables per company - why not
Posted by: Rick James
Date: January 21, 2012 12:50AM

I recommend against using different tables or different databases for essentially the same data. But I do not have a compelling reason.

* The code is messy to have to construct the table names (or database names).
* There is no performance advantage.
* If you have more than, say, 50,000 tables in one database, the Operating System will slow down -- it is not designed to be efficient with lots of files in one directory.

OTOH, WordPress does such.

Options: ReplyQuote


Subject
Written By
Posted
January 19, 2012 11:51AM
Re: tables per company - why not
January 21, 2012 12:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.