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! 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 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! 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
Archived
This topic is now archived and is closed to further replies.