Changes between Version 54 and Version 55 of Notifications

Timestamp:

Dec 11, 2009, 11:05:07 AM (14 years ago)

Author:

romw

Comment:

Formatting

Notifications

@@ -103 +103 @@
 === Project Notifications ===
 Project notifications is an umbrella feed which covers several different pieces of information including:
-•       Welcome Messages
-•       Private Messages
-•       Project News
-•       Project Milestones
-•       Friend Requests
-•       Forum Threads
-•       Forums (Any new thread created in the forum)
+ * Welcome Messages
+ * Private Messages
+ * Project News
+ * Project Milestones
+ * Friend Requests
+ * Forums
+ * Forum Threads
+
 This functionality is currently implemented using the following link:
 {{{
 http://<project_url>/notify_rss.php
 }}}
+
 The following changes should be made:
-•       Each item should belong to one or more categories the client software can use to filter on.
-‘’’NOTE:’’’ This whole feature area should be audited.  I would be surprised if 1% of the volunteer population even uses it, after this whole feature is completed 100% of the active host population will be using it.
+
+ * Each item should belong to one or more categories the client software can use to filter on.
+
+'''NOTE:''' This whole feature area should be audited.  I would be surprised if 1% of the volunteer population even uses it, after this whole feature is completed 100% of the active host population will be using it.
+
 Database queries should be batched and referenced tables should be converted from MyISAM to InnoDB, whole table locks will cause both BOINC clients and the website to stall depending on which operation(s) are in play.
+
 Preliminary investigation reveals this could be a problem area for us, one query is issued to return all the notifications, and then a new query is issued for each notification to get the details.
+
 A better strategy, using the same schema, is to issue a feeler query that’ll return hints as to which batch queries to issue.  Each positive hint will cause a new query to be issued that uses a join to merge all notification records of a certain type with the details of that type.
+
 For instance if a volunteer has 50 private messages the current scheme would result in a minimum of 51 queries issued against the database, the proposed scheme should result in 2 queries against the database.
+
 Things get progressively worse the more engaged the volunteer is, 50 private messages and 10 threads being watched would result in 61 queries issued in the current scheme, while only 3 queries would be issued in the proposed scheme.
+
 It is also important to note that the effect of the numbers increase in proportion to the number of machines attached to the project. 
+
 ==== Welcome Messages ====
 ==== Private Messages ====
@@ -128 +139 @@
 ==== Project Milestones ====
 ==== Friend Requests ====
+==== Forums ====
 ==== Forum Threads ====
-==== Forums ====
 
 === BOINC Action Feed ===