can we split the existing database

[o0O0o.o0O0o]

I have few tables in my database with 2 million entries and database is increasing day by day . Is it ok to keep that table as it is or as table grows it will cause problems. and what is the best solution

[stymiee]

2 million entries isn't a problem for modern databases. In fact it is quite common.

[demtron]

I would not split a table into multiple tables or a database into multiple databases because of growth. Any existing code such as queries, procedures, and UI code that access this one database would have to be modified to account for the additional tables or databases. This could be a really big headache.

You didn't mention what DBMS you are using, so I'm going to assume it's something modern like MySQL, MS SQL, or Oracle, in which case I agree with stymiee that 2 million rows is no big deal.

As long as your tables are normalized, you are happy with database performance, and you are not reaching any database capacity issue (example: Access databases can only be 2GB in size), I wouldn't worry about the growth you mention.

[o0O0o.o0O0o]

I am using mysql and in recent few months the database is increasing very fast . About 8Mb per day . What is the maximum capicity of mysql table or database . and once for e,g max capacity is reached waht should be done

[demtron]

Try these two links:

http://dev.mysql.com/doc/refman/5.0/en/full-table.html

http://forums.mysql.com/read.php?10,188779,188779

I suspect you'll run into OS or hardware limitations before you run into MySQL limitations.

Good luck!