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?