reducing mysql queries on main page

Register an Account
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 09-24-2008, 08:29 PM
Pligg Donor
 
Join Date: Sep 2007
Posts: 2
Construction of each link summary makes a call to pligg_saved_links table to determine if the current user has saved that link. This means 8 or 10 calls per page in total depending on the number of stories you are displaying.

I felt this was not so important, and could be displayed only on the full story page. Thus index , upcoming and search pages are now faster by 10 mysql calls!

By the way, what is the best tool to monitor the number of mysql calls being page for generation of each page, and see how much time those calls are taking?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Page Variables Yankidank Wiki Articles 3 05-19-2011 09:21 AM
Show Page Thumbnails on main page seer Questions and Comments 2 11-20-2007 05:20 AM
Show Video and images Thumbnails on main page massi999 Questions and Comments 1 11-19-2007 01:40 PM


Pligg Modules and Pligg Templates from Pligg Pro Find support on the Pligg CMS Forum - 24 hours a day! Make a donation to support Pligg CMS development