Feature #168 Details
Database: More performance by database redundancy
| Status | Assigned (ass. to yves) | Priority | Medium |
| Author | yves | Date | 01 Aug 2004 11:49 |
More performance:
make database queries faster for the price of data redundancy (what other boards already do massively)
create and manage more table columns that keep redundant information for a lot faster access
Posts.Thread
+Threads.EnhViews
+Threads.EnhReplies
+Forums.Topics
+Forums.Posts
+Forums.LastPost_Date
+Forums.LastPost_ID
+Forums.LastPost_User
+Forums.LastPost_User_Name
+Forums.LastPost_Topic_ID
+Forums.LastPost_Topic_Subject
+Forums.Level (0 = Forum 0, 1 = 1. Ebene, 2 = 2. Ebene...)
+Users.Posts
+Users.LastPost_Date
+Users.LastPost_ID
+Users.LastPost_Topic_ID
+Users.Groups = "1,2,3,4,5"
+Posts.NumInThread
HTMLCache:
Build a graph about dependencies of
- what object is modified where and
- what operation modifies what object
so that new operations keep the consistency
make database queries faster for the price of data redundancy (what other boards already do massively)
create and manage more table columns that keep redundant information for a lot faster access
Posts.Thread
+Thread_Forum
+Thread_Subject
+Thread_Desc
Posts.EditUser+EditUser_Name
Posts.User+User_Name (doppelt)
Threads.LastPostDate+LastPost_ID
+LastPost_User
+LastPost_User_Name
Threads.User+User_Name (doppelt)
+Threads.Replies (für LastPost-Link:Seite)+Threads.EnhViews
+Threads.EnhReplies
+Forums.Topics
+Forums.Posts
+Forums.LastPost_Date
+Forums.LastPost_ID
+Forums.LastPost_User
+Forums.LastPost_User_Name
+Forums.LastPost_Topic_ID
+Forums.LastPost_Topic_Subject
+Forums.Level (0 = Forum 0, 1 = 1. Ebene, 2 = 2. Ebene...)
+Users.Posts
+Users.LastPost_Date
+Users.LastPost_ID
+Users.LastPost_Topic_ID
+Users.Groups = "1,2,3,4,5"
+Posts.NumInThread
HTMLCache:
+Posts.MsgHTML
+Forums.DescriptionHTML
Build a graph about dependencies of
- what object is modified where and
- what operation modifies what object
so that new operations keep the consistency
| Keywords | |||
| Reported version | Due version | 1.7 | |
| Related tasks | #107 ([Code parser] Cache rendered HTML of posts) | ||
| Progress | 0 % | Estimated cost | Extensive work |
Changes history:
| Date | User | Action |
| 01 Aug 2004 11:49 | yves | Opened task |
| 01 Aug 2004 11:49 | yves | Changed status (New → Assigned) |
| Changed assigned user (- → yves) | ||
| Changed due version ( → 1.6) | ||
| 17 Oct 2004 19:17 | yves | Changed description |
| Changed estimated cost (Unknown → Extensive work) | ||
| 24 Oct 2004 21:35 | yves | Changed description |
| 13 Feb 2005 22:33 | yves | Changed related tasks ( → 107) |
| 16 Feb 2006 18:11 | yves | Changed description |
