Hi everyone,
I'm sure some of you have already worked on some larger projects with mySQL so here's my question:
Is there a significant performance decrease at a certain "filling" of a table? The thing is I'm building a module to enable a site to become multi-language. This means I divide the site into several logical categories, each of them represented by a table.
Each of these tables contains all texts for the category in all languages.
Now I'd like to know if it's worth the time to think about how to subdivide the larger categories so that the tables do not get slow because of too much data. In general the time needed for SELECTs should grow logarithmically but maybe there's a "limit-by-design" where performance breaks in?
As always thx in advance,
Dominique
I'm sure some of you have already worked on some larger projects with mySQL so here's my question:
Is there a significant performance decrease at a certain "filling" of a table? The thing is I'm building a module to enable a site to become multi-language. This means I divide the site into several logical categories, each of them represented by a table.
Each of these tables contains all texts for the category in all languages.
Now I'd like to know if it's worth the time to think about how to subdivide the larger categories so that the tables do not get slow because of too much data. In general the time needed for SELECTs should grow logarithmically but maybe there's a "limit-by-design" where performance breaks in?
As always thx in advance,
Dominique