 | | Gallery speed
|
| I think I've fixed the painfully slow performance of the "recent" page. There were some indexes missing in the database that really should have been there. It loads reasonably fast now (~.8 seconds unless the machine is really busy). If there are (...) (23 years ago, 5-Jul-01, to lugnet.general, lugnet.off-topic.geek)
| | | | | Re: Gallery speed
|
| (...) One speed-up would be to store the modify date/time of each folder (updated when a file is added / updated / deleted) and then query directly against the folders. It also depends on your back-end query optimiser - even if you're only selecting (...) (23 years ago, 5-Jul-01, to lugnet.off-topic.geek)
| | | | | Re: Gallery speed
|
| Kevin Loch wrote in message ... (...) 24 (...) Might be quicker to do it in 2 stages, first the line above without the DISTINCT into a cursor, then do a SELECT DISTINCT from that. SELECT file_parent FROM files ORDER BY file_modify_time DESC into (...) (23 years ago, 6-Jul-01, to lugnet.off-topic.geek)
| | | | | Re: Gallery speed
|
| Both myself and the original poster were mystified as to why this link didn't work for me - have you any idea as to why not? (URL) ... Geoffrey Hyde "Kevin Loch" <kloch@opnsys.com> wrote in message news:GG0H6J.ALE@lugnet.com... (...) LIMIT 24 (...) (...) (23 years ago, 6-Jul-01, to lugnet.general, lugnet.off-topic.geek)
| | | | | Re: Gallery speed
|
| (...) This probably wouldn't help much - the cursor isn't indexed, so the SELECT DISTINCT would be slow. A better way to split it (assuming your back-end has a decent optimiser) may be to create an index on file_parent + file_modify_time, then do: (...) (23 years ago, 6-Jul-01, to lugnet.off-topic.geek)
| | | | | Re: Gallery speed
|
| (...) I'd go for amalgamating the two steps into one query - something like: SELECT id, name, icon_information, etc. FROM file_parent WHERE file_parent.id IN (SELECT file_parent from files) This avoids the problem of having to query for DISTINCT (...) (23 years ago, 6-Jul-01, to lugnet.off-topic.geek)
| | | | | Re: Gallery speed
|
| I've also noticed on occasion when I click the "random folder" (great feature!!) a folder will display with the dreaded red "x" (no image available), and I can't click on it. Maybe this is related? ROSCO (...) (23 years ago, 9-Jul-01, to lugnet.general, lugnet.off-topic.geek)
| |
