I need some advice from the pro's :)
I am building an application that has data from several places. The structure is all the same but the data is specific to a user.
1 such a feed can consist of 50,000 rows but on average it's more between 500-2000 rows. In total there will be about a 400 different tables.
I am in doubt if I should merge all data into 1 big table. The number of rows will go beyond 2 million I suspect.
My main "problem" is I want to be able to search and select
in the description and title column and that should be done over all tables if I keep it the original way.
What is the best way to tackle this. Something to note is that the search and select is at the backend where no actual visitor will be bothered as they only see the end result.