Great post Janine! thx.
You should change to aol4.0.8, its quite stable now and SSL is working fine as well ... and its much faster that 3.x series.
Galileo is using postgres 7.4.3, and we have been fixing several queries with bad performance, stuff like:
* left join
* wheres x is not in (...)
* and some inline query function calls
are giving bad performance, we have commited most of our changes, now working on put as list builders all the tables on /dotlrn/admin is anybody else working on that as well? (in order to avoid duplicate efforts); this is really important as admin UI for dotlrn.
Though the experience so far has been really good (linux, pg, aol, oacs, .LRN), about 0.5 secs in average for serving any page. Also we moved all of the files (lobs) in the DB to the file system giving us better performance on serving those as well.
