Forum .LRN Q&A: Re: Some quickly thoughts about our experience with dotlrn.

Hello again!

<blockquote>I don't understand this:
-Possibility of filing courses to unload of objects the data base at end of courses (I think of there are some package for Oracle related with this)
</blockquote>

Well, we are detected that one of the performance problems in a big installation is the number of objects in the DB. I know to store the courses history for several years is very attractive but we are scared about performance. Do you archive the old classes or keep it online like a normal class?

<blockquote>Agustin, thank you for sharing your experience! Out of curiosity can you please give full specifications of your hardware. How much RAM etc.
</blockquote>

Aolserver -> Dual Opteron 1.5 GHz 4 GB RAM SCSI local disk
Postgres  -> Dual Opteron 2.0 GHz 4 GB RAM SCSI fiberchannel

Other thing: We are thinking of in develop something for the files quote system. Are there any thing implemented?
Any idea? What would be the best way to do that?

Regards,
Agustin

<blockquote>Do you archive the old classes or keep it online like a normal class?
</blockquote>

Yes, we do, and I dont think the number of objects will decrease your performance, some procedures are related to decrease of performance (like class instantiation), but not the amount of objects per se.

For fs ideas look at:
https://openacs.org/forums/message-view?message_id=213667