Feature #168 Details

Database: More performance by database redundancy

StatusAssigned (ass. to yves)PriorityMedium
AuthoryvesDate01 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
+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 (fr 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 versionDue version1.7
Related tasks#107 ([Code parser] Cache rendered HTML of posts)
Progress
  0 %
Estimated costExtensive work
Changes history:
DateUserAction
01 Aug 2004 11:49yvesOpened task
01 Aug 2004 11:49yvesChanged status (New → Assigned)
  Changed assigned user ( → yves)
  Changed due version ( → 1.6)
17 Oct 2004 19:17yvesChanged description
  Changed estimated cost (Unknown → Extensive work)
24 Oct 2004 21:35yvesChanged description
13 Feb 2005 22:33yvesChanged related tasks ( → 107)
16 Feb 2006 18:11yvesChanged description
© 2003–2017 by Yves Goergen web1@unclassified.de
Content last updated on 2006-02-16 18:11
dotforward webhosting Get Firefox XHTML 1.1 CSS