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?
|