On mar, 2003-01-07 at 15:06, Tomasz Wegrzanowski wrote:
On Tue, Jan 07, 2003 at 11:40:10PM +0100, Paul Ebermann wrote:
So for each new language a new table. Why? Doesn't a language field in one article table would be enough?
It should be faster that way, because locking issues on English tables won't cause any problems for us.
And too many English articles won't cause selects to be any slower for other languages that way.
I think a better approach is to make the system work more smoothly so that neither the other languages _nor_ the English section have to suffer from the English section's large number of articles.
Separate tables in the same database won't be any better than separate databases on the same server, which presently causes problems because the English tables will get locked up and additional requests get backed up until the server hits its open connection limit -- then other languages can't connect either, and you just have to wait it out.
If we can iron out the locks, I believe a combined table system will be both more flexible and easier to program against.
-- brion vibber (brion @ pobox.com)