[Contrib: Evaluation System] My Evaluations list getting really long

[Verity Allan]

Hi,

I don't know of a fix for this; I can unfortunately confirm that it will 
become impossible to load the surveys in the Evaluation System tool in the 
Admin Workspace, as it will time out. We have well over 10,000 surveys 
now, and while we can administer the options using the 'Administrate' 
link, the 'My Surveys' link is a no-no. (And during peak survey times, My 
Current Surveys has hundreds of surveys in and takes ages to load.)

This does mean that the only way of finding out about certain surveys is 
to use the 'become user' tool to 'become' the person who's running the 
survey. This is a bit of a pain, but does mean that you can do some 
troubleshooting via the UI, rather than via the DB.

I can see that users might well want to look at last year's surveys, but 
that does leave us with this problem in the Admin Workspace. Maybe 
implementing paging of the results would help?

So, while there's a certain amount you can achieve by workarounds, it's 
pretty inconvenient, and we'd be interested in testing a fix, should 
someone come up with one. (We don't currently have time to work on one 
ourselves.)

Regards,
Verity
CamTools Helpdesk
CARET, University of Cambridge

> Date: Thu, 11 Aug 2011 14:49:47 +0100
> From: Adam Marshall <adam.marshall at oucs.ox.ac.uk>
> Subject: Re: [Contrib: Evaluation System] My Evaluations list getting
> 	really long
> To: Jim Eng <jimeng at umich.edu>
> Cc: evaluation <evaluation at collab.sakaiproject.org>
> Message-ID:
> 	<DF192BAB00144C48B1B41464F3347A2041A514C3EE at EXMBX05.ad.oak.ox.ac.uk>
> Content-Type: text/plain; charset="us-ascii"
>
> We're not that bothered about clearing out data. It's the number of items on the 'admin' user 'my surveys' page. It is taking 3-4 minutes to load and I'm soon that we'll soon see a time out.
>
> adam
>
> From: Jim Eng [mailto:jimeng at umich.edu]
> Sent: 11 August 2011 14:37
> To: Adam Marshall
> Cc: Paul Dagnall; evaluation
> Subject: Re: [Contrib: Evaluation System] My Evaluations list getting really long
>
> We have a different situation than most schools, because our evals are imported from an external system and administered in Sakai, and the responses are exported back to the external system, through which results are reported back to instructors and others.  After the responses are exported, we delete the data from Sakai, using SQL scripts.
>
> There are dangers inherent in keeping old eval data inside Sakai, so we now get rid of it as soon as possible after each term ends.
>
> That may not match other people's needs, especially if users need to refer to results long after an eval closes and there is no external system for archiving and reporting historic data.
>
> I would advise that you clean out the old data as early as possible, which would solve the problem you mentioned.
>
> Jim
>
>
>
>
> On Aug 11, 2011, at 5:38 AM, Adam Marshall wrote:
>
>
> I don't know any way of doing this but for us this is getting to be an issue.
>
> We were thinking of doing some work to address this, eg, by default, only display surveys from the last 3 months and have a date range selector at the top of the page. As a first stage I think we now display the surveys in reverse chronological order.
>
> If somebody else has a patch or is intending to do some work then that would probably suit us?
>
> To be honest I cant see us having any time to do this in the next 3-4 months.
>
> adam
>
> From: evaluation-bounces at collab.sakaiproject.org<mailto:evaluation-bounces at collab.sakaiproject.org> [mailto:evaluation-bounces at collab.sakaiproject.org] On Behalf Of Paul Dagnall
> Sent: 09 August 2011 18:23
> To: evaluation
> Subject: [Contrib: Evaluation System] My Evaluations list getting really long
>
> Hi
> Are there any settings that can be used to control how long the "My Evaluations" list gets? Other than deleting them I don't see a way to trim the list of old Closed Evaluations.
>
> Thank you.
>
> Paul Dagnall
> Web Developer
> University of Dayton
> _______________________________________________
> evaluation mailing list
> evaluation at collab.sakaiproject.org<mailto:evaluation at collab.sakaiproject.org>
> http://collab.sakaiproject.org/mailman/listinfo/evaluation
>
> TO UNSUBSCRIBE: send email to evaluation-unsubscribe at collab.sakaiproject.org<mailto:evaluation-unsubscribe at collab.sakaiproject.org> with a subject of "unsubscribe"
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://collab.sakaiproject.org/pipermail/evaluation/attachments/20110811/d89ed1ec/attachment.html
>
> ------------------------------
>
> _______________________________________________
> evaluation mailing list
> evaluation at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/evaluation
>
>
> End of evaluation Digest, Vol 30, Issue 6
> *****************************************
>