 | | 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
|
| (...) 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)
| |
