I'm making a database which should be able to handle over 1,000,000,000 rows.
in order to optimize it's performance i've decided to split tables.
so instead of having 1,000,000,000 entries in one table for over 10 years i would split it to 3650 tables and one table for each day.
there would be no more than join or union of 2 queries now i want to know wether having too many tables degrade performance or not and if so How much ?