| |
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?
http://www.brickshelf.com/cgi-bin/gallery.cgi?f=5229
--
Cheers ...
Geoffrey Hyde
"Kevin Loch" <kloch@opnsys.com> wrote in message
news:GG0H6J.ALE@lugnet.com...
> 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 any database wizards out there, maybe you can help make it
> even faster.
>
> here's the "slow" query that is currently limiting performance:
>
> SELECT DISTINCT file_parent FROM files ORDER BY file_modify_time DESC • LIMIT 24
>
> each file_parent is then used to retrieve a folder record with icon • information
> etc. Those 24 queries are extremely fast (0.01 secs ea) so that's not the
> problem. I do have indexes for file parent and file_modify_time.
>
> Most queryies return ~instantly (0.01 secs), but the above query returns
> in 0.76 seconds. Is there a faster way to do this?
>
> It would be much faster to do this:
> SELECT * FROM files ORDER BY file_modify_time DESC LIMIT 24
>
> but that would include empty folders.
>
> omitting the DISTINCT above causes it to return instanly but with many
> duplicates, since there is often more than one new image per folder.
>
> KL
|
|
Message has 1 Reply:
 | | 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 (...) (25 years ago, 9-Jul-01, to lugnet.general, lugnet.off-topic.geek)
|
Message is in Reply To:
| | 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 (...) (25 years ago, 5-Jul-01, to lugnet.general, lugnet.off-topic.geek)
|
7 Messages in This Thread:
 
- Entire Thread on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
This Message and its Replies on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
|
|
