Thread: Slow Queries
View Single Post
Old November 3rd, 2012, 12:50 PM   #6 (permalink)
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,689
There is no way to an some index as there are already the proper indexes.

The only other suggestion is try setting ROWS EXAMINED statement for certain things.

First say in showphoto.php for the exif info line 575 you could add say maybe the code in bold but test it

Code:
Content visible to verified customers only.
Then in pp-inc.php for your display_gallery function these statements add the code in bold

Code:
Content visible to verified customers only.
You can test that everything works fine and see the speed difference
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote