[lazytown]

This is a fantastic mod! I have one problem and one suggestion.

Major Problem: With a lot of attachments, the page load time and cpu/mysql usage, even for a single viewer, is way too long. This will destroy my server with lots of users if I make it live. It's obviously doing some serious mysql table scans of some kind. I have over 32,000 attachment images on this forum, which isn't THAT many. When I turn off attachments as a gallery, the page loads almost instant (6000+ pictures in member albums is no problem for it). It is MUCH slower on the gallery home page than it is on the individual attachment pages, even on the attachment pages with lots of pages are faster (going page by page -- they're slow, but not nearly as slow as the main page).

So What can be done to speed the query up? Are there some columns/tables I can index that are being scanned? Is there something in the code that can be changed? Perhaps at least for the homepage, it should cache every so often instead of scanning each time or the query can be limited to the past XX days. The gallery stats could at least be cached every hour/day since no pictures are displayed on the gallery home, it shouldn't take so long. In fact I could do without the stats if that helped, but it didn't (tried turning them off).

Feature Request: Obviously the software already is smart enough to show members attachments per forum section with the filter option.. What I'd really love to see is on the category pages (main gallery page), the option to have each forum section listed as a subsection of 'attachments.'' So it would look almost like the main forum page, but only be pictures. This is possible since you already created a filter, but it's not implemented. This would really be great and if we could limit it to only show certain forum sections it would be so amazing!! (for example, if I have a car forum, people could click on the corvette or porche subforum for only those attachment pictures... And the help/off-topic forums with attachments would not be shown at all).

Thank you!