Installed dotlrn on debian with openACS4.6 and postgres 7.2.1 - found it to be extremely slow, on a reasonably high spec machine. On running vmstat - saw that it's because at one stage it pulls 15MB off the disk in one request.
It seems to happen whenever the
<span>#
</span>dotlrn-fs.Lecture-Notes# portlet is used in a class, or
<span>#
</span>fs-portlet.pretty_name# - even if there are no added files. Checking what is going on in postgres, it seems that there is a particularly huge select statement, which, even if run of the pgsql command line, takes an age to return a (very small) table of results:
select fs_objects.object_id, fs_objects.name, fs_objects.live_revision, fs_objects.type, to_char(fs_objects.last_modified, 'YYYY-MM-DD HH24:MI:SS') as last_modified,fs_objects.content_size, fs_objects.url, fs_objects.sort_key, fs_objects.file_upload_name, etc etc etc etc etc etc etc.
Is this a statement that that has been optimised in some way for oracle?