damianjames Posted September 13, 2010 Share Posted September 13, 2010 Hi all - I'm writing a little piece of blog software for the pastor of my church, and I'm wondering database-wise how to attack it. When it comes to performance, when you have a small amount of rows being returned from a relatively small dataset, is it more efficient to store everything in one table? id (PK) date (date) title-es (varchar) title-en (varchar) post-es (text) post-en (text) author (enum) category (varchar) active (bool) The main question I'm concerning myself with is to split the languages or not. Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/213320-one-table-vs-multiple-for-multi-language-blog/ Share on other sites More sharing options...
shlumph Posted September 13, 2010 Share Posted September 13, 2010 The table looks pretty good, however, I'd do something like this: id (PK) date (date) title (varchar) post (text) author (enum) category (varchar) active (bool) language (varchar) - this can be es/en, or, whatever languages you might come up with in the future It should make your coding much easier Quote Link to comment https://forums.phpfreaks.com/topic/213320-one-table-vs-multiple-for-multi-language-blog/#findComment-1110711 Share on other sites More sharing options...
damianjames Posted September 14, 2010 Author Share Posted September 14, 2010 Thanks for the help! Quote Link to comment https://forums.phpfreaks.com/topic/213320-one-table-vs-multiple-for-multi-language-blog/#findComment-1110850 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.