Forum .LRN Q&A: Re: Res: Re: Problems with assessments
We are using, in production, Postgres 8.1.4.
Related with tcl / xql files:
-We have the next line:
db_dml lock_objects "LOCK TABLE acs_objects IN SHARE
ROW EXCLUSIVE MODE"
-We have in psql the next procs locking acs_objects:
content_item__new (overloaded 20, 17 and 16 parms)
content_revision__new (13 parameters)
Any help, please?
(We have observed counted more than 150 locks (pg_locks)
for every assessment answer inserted in Pg!)
Are there any Pg conf parameter to tune these numbers?
The assessment has certain weaknesses in design. I am afraid, to reach a significant better performance, the assessment should be re-engineered.
But what numbers are you telling?
How many simultaneous assessments are you trying
in your center?
For course evaluation, we use assessment module, but only in a few parts. Currently, we are running evaluations for 1200 courses reaching most of our students (20000). We do this currently not online, but based on a paper & scanner based solution. We have quite a complex system tailored to the needs of our university. We have plans to offer the teachers in addition to the paper based system online assessments but this will need some work to run smoothly in this scale.
In autumn we were running a few smaller assessments (a few questionnaires for a few hundred students each) with mixed experiences.
Our 'learn' system predated .LRN, but was merged when .LRN came out in parts. Last time, i checked, our system differs from OpenACS/.LRN in about 15.000 changes.
We are not only running the learn system, but have about 20 OpenACS/.LRN sites within the university for various purposes, and similar numbers for customer sites, supported through our university spin off Knowledge Markets https://www.km.co.at. Knowledge Markets runs a site for customer assessments https://www.evaluate.at/ using the assessment module. It runs there with the mentioned changes, but i cant say, how many simultaneous assessments are usually filled out there.