[Building Sakai] Message center performance question

[Bryan Holladay]

I would advise just upgrading to the latest version of Msgcntr if you are having performance problems.  There have been a lot of performance related improvements added since Msgcntr 2.6.  The latest is 2.7.x or 2.7.3, with 2.8 coming pretty soon.  They all run with Sakai 2.6, it just takes a small pom change to get it to build (2.8 requires a jQuery file in /library/js/jquery-ui-latest/js/jquery.min.js).  Two things you'll want to consider are: 

1) You may want to run the Synoptic data quartz job to pre-fill the synoptic table with data (provides a seamless upgrade since the synoptic tool is different in 2.7+).  This isn't required and the data will populate itself as users use the tool.
2) Verify that you have all the correct Indexes in the tables: (https://source.sakaiproject.org/svn/msgcntr/trunk/messageforums-hbm/src/sql/mysql/msgcntr_indexes_only.sql)


Thanks,
Bryan


On Mar 8, 2011, at 4:17 AM, DAVID ROLDAN MARTINEZ wrote:

> Hi all
> 
> We are running under Sakai 2.6.x and KNL 1.0.12 in production.
> 
> We have found that the following two queries are executed up to 7 times and don't know why even which piece of code is the responsible:
> 
> select count(*) as col_0_0_ from MFR_MESSAGE_T messageimp0_ where 
> messageimp0_.surrogateKey=? and messageimp0_.DRAFT=0 and 
> messageimp0_.DELETED=0
> 
> select count(*) as col_0_0_ from MFR_MESSAGE_T messageimp0_, 
> MFR_UNREAD_STATUS_T unreadstat1_ where messageimp0_.surrogateKey=? and 
> unreadstat1_.USER_C=? and messageimp0_.ID=unreadstat1_.MESSAGE_C and 
> unreadstat1_.READ_C=1 and messageimp0_.DRAFT=0 and messageimp0_.DELETED=0
> 
> 
> On the other hand, does anybody know if MsgCntr 2.7 is compatible with Sakai 2.6.x? If we upgrade MsgCntr version, do you think we will get a significative performance improvement?
> 
> Thank you very much in advance.
> 
> Cheers,
> 	David
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> 
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"