haiku-files.org is snappy, but haiku-files.org/raw, /vmware, /cd are not

[luroh]

​http://haiku-files.org responds very quickly while ​http://haiku-files.org/raw/, ​http://haiku-files.org/vmware/ and ​http://haiku-files.org/cd/ do not.

Two possible clues as to what's going on (as picked up on IRC):

"org/ is pure html, raw/, cd/, vmware/ are php"
"it enumerates the whole dir and tries to match filetypes to thumbs and such"

[axeld]

The site is using a very poorly done PHP script that refills a MySQL database (with each visit) just for sorting and filtering the entries. I've already complained about this since forever. Patches welcome!

[kwurzel]

We could just use the (styled) output of Apache's mod_autoindex (see ​http://recurser.com/articles/2008/12/29/styling-apache-directory-listings-with-mod_autoindex/ for an explanation). I think Canonical uses it at ​http://releases.ubuntu.com/9.04/ for example.

Alternatively, we could use a simple PHP Directory listing script like ​http://www.evoluted.net/community/code/directorylisting.php

I would prefer the first one, as it is much faster (at least in theory)...

[mmlr]

I'm reworking it.

[mmlr]

Done. Reworked them, stripped unneeded stuff, sort using PHP, reformat to have a coding style, style the output as well, simplified. Should perform reasonably now.