Forum .LRN Q&A: Re: Res: Assessment is killing our .LRN.

Collapse
5: Re: Res: Assessment is killing our .LRN. (response to 1)
Posted by Dario Roig on 02/18/09 03:31 PM
Hi Hector!
In this link you can view our file
http://aulavirtual.uv.es/ficheros/view/dotlrn-uv-packages/assessment/asxitemxtypexmcxprocsxpostgresql.xql

We have rewritten this select for best performance.

Thanks by advice

Collapse
6: Re: Res: Re: Res: Assessment is killing our .LRN. (response to 5)
Posted by Hector Amado on 02/19/09 09:56 PM
Hi Dario! , you can test with the new revision in as-item-type-mc-procs.tcl, http://cvs.openacs.org/cvs/openacs-4/packages/assessment/tcl/as-item-type-mc-procs-postgresql.xql?revision=1.5&view=markup&sortby=file this is for multiple choice questions.
Try updating assessment package.

In the new revision you don't use r2.revision_id as content_rev_id, r2.title as content_filename and i.content_type

Best regards,