[Building Sakai] Response time problem (resources and Test& quiz) reverting for DB to file system

[Lafontaine Lyse]

Hello all!

 Yesterday, I sent an email asking for help with our problem with response time (see the email below).    Because we want to be in production next week.... we've decided to go back to our first architecture where the resources are kept in a file system separate for the Oracle DB (Oracle 10G).  As written in the doc, we've commented out convertToFile  in sakai.properties .   Any new files gets created in the file system but all resources already in the DB are not  accessible anymore and are also not converted  to the file system.... We are running Sakai 2.6

Any help would be very welcome. 

Lyse

 

Previous email.....

  We're about to start our 1st pilot at University of Montreal and we face a serious problem with response time.  

On Monday, we've moved all resources from the file system to the Oracle DB for internal reasons.  

Since that, we've run into response time problem.  Particularly painful, is  Tests & Quiz (up to 30 sec  when copying question pools).  We're also impacted when we open any non empty folder.  

 

Do you know of any specific setup  we've missed?  Why is Test & Quiz  particularly impacted by this move?  Any suggestion to help us because we are wondering if we have 1 or more problems?

 

 

Lyse Lafontaine  |  Gestionnaire de projet
Projet ENA  |  Université de Montréal

 

T. 514 343 6111 poste 1-55324#

	
	
  <http://momentum.umontreal.ca/les-projets/environnement-numerique-dapprentissage/introduction> 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100416/8a10970e/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 3664 bytes
Desc: image001.jpg
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100416/8a10970e/attachment.jpe