Larger Tables

So there are limits to table sizes in MySQL.  So how do people use multiple tables like the following.  If I want to replicate the main property table how difficult is it to have multiple tables with say 500,000 records in each table?  Separated perhaps by counties or some qualifier.  I wonder how many records can one table hold and still function efficiently?  Has someone else used multiple duplicate tables?  If you search this county it goes to that table.  If you edit a property it would go to the right table... 

OK really I am the only one that is asking such a question well let me turn it towards what maybe ALL of us should be thinking about?  What will you do if you have 650,000 members on your site?  What will you do then with the profile table?  In other words you reach capacity for the profile table...Which is about right for me with properties I think?  How many entries can a table function with properly?

I had a MYSQL table with more then 1mil rows and worked fine. had multiple links with other tables.
but it wasn't Dolphin based.

But I agree... maybe the site info you store should be split and the DB design should be based on region or country.
that way you will prevent future issues in your case.

You will need to provide a reference to where you obtained information about such limits. The Profile table for example uses and unsigned int(10) index. Meaning it can hold 4,294,967,295 (4 Billion) records before it has problems. That can be changed to increase it if necessary.

Only limit i am aware of would be file system limits on the data storage size of the table on disk. http://dev.mysql.com/doc/refman/5.0/en/table-size-limit.html   NOTE: Modern ext4 systems are not on that list which have a 16TB limit.

Perhaps i could see a possible problem on sites like facebook. But i do not know of any dolphin sites that could even come close to hitting such limits.

If you have evidence that shows a serious limit with modern servers than point it out.