Go Back   Pligg CMS Forum > Pligg Development > Modification Tutorials

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 09-24-2008, 07:29 PM
Pligg Donor
 
Join Date: Sep 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Smile reducing mysql queries on main page

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
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Similar Threads
Thread Thread Starter Forum Replies Last Post
Page Variables Yankidank Wiki Articles 1 08-13-2008 03:59 AM
Page Numbers in main page.... vgreets General Help 0 01-10-2008 09:27 PM
Show Page Thumbnails on main page seer General Help 2 11-20-2007 04:20 AM
Show Video and images Thumbnails on main page massi999 General Help 1 11-19-2007 12:40 PM


Search Engine Friendly URLs by vBSEO 3.2.0