| |
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
In lugnet.general, Geoffrey Hyde writes:
> 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
>
> "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 is in Reply To:
 | | 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 (...) (...) (25 years ago, 6-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
|
|
|
|
