Foreign keys vs partitioning

Question

Hi!

Since foreign keys are not supported by partitioned mySQL databases for the moment, I would like to hear some pro's and con's for a read-heavy application that will handle around 1-400 000 rows per table. Unfortunately, I dont have enough experience yet in this area to make the conclusion by myself...

Thanks a lot!

References:

http://stackoverflow.com/questions/1537219/how-to-handle-foreign-key-while-partitioning

http://stackoverflow.com/questions/2496140/mysql-partitioning-with-foreign-keys

Answer 1

Well, if you need partitioning for a table as small as 400.000 rows get another database than MySQL. Seriously. By modern standards any table below 1.000.000 rows is normally neglegible in size (not even small), unless you also dont have any index etc. And modern standards are about 10 years old in this regard.