for the maximum number of tables in a database.
I'm thinking about separating a table with up to millions of rows into
several tables with the same set of columns to speed up some complex
queries. As the size of the original table is increasing fast, I want
to get it separated once the size grows up to a limit. So there
will be a large amount of tables (having same structure) in a database. Is
there any potential performance problem with this design?
Thanks.
Li Li