[LON-CAPA-users] Slow spreadsheet calculations

lon-capa-users@mail.lon-capa.org lon-capa-users@mail.lon-capa.org
Fri, 29 Dec 2006 18:14:15 -0500


<div>Wow. So these guys using the system to do 6000 students have to run 50=
 hours to get their spreadsheet? Or is this due to running on educog?<br><b=
r>brew<br></div><font color=3D"#990099">-----lon-capa-users-admin@mail.lon-=
capa.org wrote: -----<br><br></font><blockquote style=3D"border-left: 2px s=
olid rgb(0, 0, 0); padding-right: 0px; padding-left: 5px; margin-left: 5px;=
 margin-right: 0px;">To: lon-capa-users@mail.lon-capa.org<br>From: Felicia =
Berryman &lt;felicia@lon-capa.org&gt;<br>Sent by: lon-capa-users-admin@mail=
.lon-capa.org<br>Date: 12/29/2006 12:38PM<br>Subject: Re: [LON-CAPA-users] =
Slow spreadsheet calculations<br><br>


 =20


Hi Brew, <br><br>
<blockquote cite=3D"midOF71D2F291.E4501B15-ON85257252.007DD25F-85257252.007=
DD262@notes.monroe.edu" type=3D"cite"><font size=3D"2">I am looking for sug=
gestions on speeding up
he spreadsheet calculations for my courses. Currently, each student
takes 25-30 seconds to calculate, so a class of 20 students takes 10
minutes or more to calculate. This seems a little excessive...:)<br>
 =20
</font></blockquote>
<font size=3D"2">There are some minor changes=20
</font><font size=3D"2">LON-CAPA
2.3=20
</font><font size=3D"2">to speed up the spreadsheet.&nbsp; The
spreadsheet accesses so much data for each problem for each student
that it takes a long time.&nbsp; Not that you want to hear this, but 10
minutes is considerably faster than what it used to take a few versions
ago.&nbsp; <br><br>
Felicia<br>
</font>
<font face=3D"monospace" size=3D"3">-- <br>Felicia Berryman<br>LON-CAPA Sup=
port Coordinator<br>Michigan State University<br>Phone: &nbsp;(517)432-9866=
<br>Technical Support Available at:<br> &nbsp; <br><a class=3D"moz-txt-link=
-freetext" href=3D"http://www.loncapa.msu.edu">http://www.loncapa.msu.edu<b=
r></a> - MSU Users<br> &nbsp; <br><a class=3D"moz-txt-link-freetext" href=
=3D"http://www.help.lon-capa.org">http://www.help.lon-capa.org<br></a> - Ge=
neral<br></font>
=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=
=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F
LON-CAPA-users mailing list
LON-CAPA-users@mail.lon-capa.org
http://mail.lon-capa.org/mailman/listinfo/lon-capa-users
</blockquote><br>=