Forum OpenACS Development: Response to OpenACS 4 file storage slow query

Collapse
Posted by Jun Yamog on
Hi,

I got back on this issue again today.  On further investigation it seems only the fs_files, fs_folders makes use of the plsql function file_storage__get_package_id.  They just use it to make the "url" column.  Now the url column of the views fs_files, fs_folders, fs_folders_and_files does not seem to be used.

So I set the url columns to be nulls and recreate the views and its  faster now.  I am not talking about milliseconds faster but just looking at a page load.  I don't need some fancy benchmark to tell me that it is now faster since it was so slow before.  I will now have our testers test it.

Since Yon's new file-storage may not be in for 4.5 don't you think that this qualifies for a bug fix for 4.5 final?