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

Collapse
Posted by Dario Roig on
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
Posted by Hector Amado on
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,