To LUGNET HomepageTo LUGNET News HomepageTo LUGNET Guide Homepage
 Help on Searching
 
Post new message to lugnet.off-topic.geekOpen lugnet.off-topic.geek in your NNTP NewsreaderTo LUGNET News Traffic PageSign In (Members)
 Off-Topic / Geek / 3165
    Re: Gallery speed —Kevin Wilson
   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 —Ross Crawford
   (...) 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)
 

©2005 LUGNET. All rights reserved. - hosted by steinbruch.info GbR