|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
Hi I’m wondering why you don’t spilt the post and thread tables into two tables for each, one for hot threads and the other for warm threads. I mean by hot threads is the active one which currently receive a lot of requests (SELECT, INSERT, UPDATE, and DELETE). For example, we can consider any thread that have been posted or have one post during the past 3 days to be a hot thread. So, its will be stored into a HotThread and HotPost table. After 3 days from the last post the thread and its post should be moved to a warm tables which containe all threads in the forum. The active threads are the most important threads in the forum, they are what we care about now and we need a better actions' time over them. I belief the performance of the DBMS will be improved if we distinguish between active and inactive threads. Mysql will have an easy task to retrieve the requested thread and all its posts on hundreds of records, rather than over millions of mixed posts and threads. Regards, __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
vB4 Remove 'Post New Thread' and 'Reply to Thread' buttons when users have no permission | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 05-21-2010 02:00 AM |
Forum Reply to Thread - Auto-citation Orginal Thread Content | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 05-12-2010 06:50 AM |
Subscribe to This Thread option missing from Thread Tools menu for some users | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 03-18-2010 02:30 PM |
Forum Post icons not showing up in editor/before entering thread (but works when in thread) | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 12-25-2009 05:48 AM |
The world's most warm boots | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 11-16-2009 08:00 AM |