Jump to content

(DP34) Advanced Thumbnails


DawPi

Recommended Posts

  • 1 month later...
  • Replies 239
  • Created
  • Last Reply
  • 4 weeks later...
  • 2 weeks later...

This mod is acking odd on my site. It may be something Im doing wrong. I set it for a forum topic and the first few pages have icons from the post in the topic, after about two pages in I get all the same photo for every topic. Can you help?

post-403748-0-18955900-1389735126_thumb.

Link to comment
Share on other sites

  • 9 months later...
  • 1 month later...

I am having serious performance issues when this hook is active. I believe this query is done by the hook and it is very inefficient.

 

# Query_time: 196.108194  Lock_time: 0.000164 Rows_sent: 39  Rows_examined: 370169
SET timestamp=1416596487;
SELECT t.tid,p.post_key, p.post,a.attach_thumb_location, a.attach_location FROM topics t  LEFT JOIN posts p ON ( t.tid = p.topic_id AND p.new_topic = 1 )
 LEFT JOIN attachments a ON ( a.attach_post_key = p.post_key AND a.attach_is_image = 1 )   WHERE t.tid IN (72353,160177,160134,160003,159909,159911,159912,159908,160151,159863,159829,160124,160123,160122,160078,154892,160085,159917,130871,160051,160050,136539,160027,160026,160022,160023,160002,159991,159717,159971 ) ORDER BY a.attach_date DESC;

 

Any way we can reduce the number of rows examined?

 

steve k.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.

×
×
  • Create New...