[Building Sakai] site-manage question

[Omer Piperdi]

We are using Oracle 10.2.0.4.

 From clicking of Create site button, following entries appears in 
catalina.out after about 30 seconds.. (I am not sure if these query 
depends on the tools that I chose during the site creation)

-----------------------
Hibernate: select gradebook0_.ID as ID57_, gradebook0_.VERSION as 
VERSION57_, gradebook0_.GRADEBOOK_UID as GRADEBOOK3_57_, 
gradebook0_.NAME as NAME57_, gradebook0_.SELECTED_GRADE_MAPPING_ID as 
SELECTED5_57_, gradebook0_.ASSIGNMENTS_DISPLAYED as ASSIGNME6_57_, 
gradebook0_.COURSE_GRADE_DISPLAYED as COURSE7_57_, 
gradebook0_.ALL_ASSIGNMENTS_ENTERED as ALL8_57_, gradebook0_.LOCKED as 
LOCKED57_, gradebook0_.GRADE_TYPE as GRADE10_57_, 
gradebook0_.CATEGORY_TYPE as CATEGORY11_57_, 
gradebook0_.IS_EQUAL_WEIGHT_CATS as IS12_57_, 
gradebook0_.IS_SCALED_EXTRA_CREDIT as IS13_57_, gradebook0_.DO_SHOW_MEAN 
as DO14_57_, gradebook0_.DO_SHOW_MEDIAN as DO15_57_, 
gradebook0_.DO_SHOW_MODE as DO16_57_, gradebook0_.DO_SHOW_RANK as 
DO17_57_, gradebook0_.DO_SHOW_ITEM_STATS as DO18_57_ from GB_GRADEBOOK_T 
gradebook0_ where gradebook0_.GRADEBOOK_UID=?
Hibernate: select sitetool0_.id as id1_, sitetool0_.site_id as site2_1_, 
sitetool0_.tool_id as tool3_1_, sitetool0_.listener_id as listener4_1_ 
from osp_site_tool sitetool0_ where site_id=?
Hibernate: select gradebook0_.ID as ID57_, gradebook0_.VERSION as 
VERSION57_, gradebook0_.GRADEBOOK_UID as GRADEBOOK3_57_, 
gradebook0_.NAME as NAME57_, gradebook0_.SELECTED_GRADE_MAPPING_ID as 
SELECTED5_57_, gradebook0_.ASSIGNMENTS_DISPLAYED as ASSIGNME6_57_, 
gradebook0_.COURSE_GRADE_DISPLAYED as COURSE7_57_, 
gradebook0_.ALL_ASSIGNMENTS_ENTERED as ALL8_57_, gradebook0_.LOCKED as 
LOCKED57_, gradebook0_.GRADE_TYPE as GRADE10_57_, 
gradebook0_.CATEGORY_TYPE as CATEGORY11_57_, 
gradebook0_.IS_EQUAL_WEIGHT_CATS as IS12_57_, 
gradebook0_.IS_SCALED_EXTRA_CREDIT as IS13_57_, gradebook0_.DO_SHOW_MEAN 
as DO14_57_, gradebook0_.DO_SHOW_MEDIAN as DO15_57_, 
gradebook0_.DO_SHOW_MODE as DO16_57_, gradebook0_.DO_SHOW_RANK as 
DO17_57_, gradebook0_.DO_SHOW_ITEM_STATS as DO18_57_ from GB_GRADEBOOK_T 
gradebook0_ where gradebook0_.GRADEBOOK_UID=?
Hibernate: select sitetool0_.id as id1_, sitetool0_.site_id as site2_1_, 
sitetool0_.tool_id as tool3_1_, sitetool0_.listener_id as listener4_1_ 
from osp_site_tool sitetool0_ where site_id=?
-----------------------


Thanks
Omer

On 8/1/2011 10:41 AM, Sam Ottenhoff wrote:
> I've never seen that behavior before. Database you are using? Results
> from a slow query log?
>
> On Mon, Aug 1, 2011 at 11:20 AM, Omer Piperdi<omer at rice.edu>  wrote:
>> After upgrading our database to 2.8, it is taking about 30 seconds to
>> create a project site.
>>
>> I tried both 2.8.x branch and 2.8.0 of site-mange but they are taking
>> about the same time. Does anyone see something like this before? There
>> is nothing in catalina.out or hibernate debug.
>>
>> Thanks
>> Omer
>> _______________________________________________
>> 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"
>>
>
> !DSPAM:2294,4e36c92b217091087116449!
>
>