PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > PhotoPost Pro Support Forums > Photopost Pro How Do I...?

Photopost Pro How Do I...? Wondering how to do things in PhotoPost?

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old February 23rd, 2007, 08:57 AM   #1 (permalink)
Member
 
Join Date: Jan 2007
Posts: 86
Findout Individual Queries and their loading time

How do I findout individual queries and their loading time.

For eg:

Page generated in 2.43096 seconds with 14 queries
1: SELECT timestamp,statscache,catcache,catprops FROM cache WHERE id=1 (0.41623 sec)
2: SELECT u.userid,u.username,u.email,u.password,u.usergroupid,u.timezoneoffset,s.sessionhash,u.salt,u.membergroupids FROM user u LEFT JOIN session s ON s.userid=u.userid WHERE u.userid=1 (0.00276 sec)

I picked up the following from one post. I would also like to know which softwares are good to debug php/mysql queries and provide suggestions.
mihirp is offline   Reply With Quote
Old February 23rd, 2007, 09:06 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,806
In pp-inc.php find this variable $showsqldebug and set it from 0 to a 2
__________________
Photopost Developer and Support Engineer

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


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

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
Check Page Loading Time mihirp Photopost Pro How Do I...? 1 February 21st, 2007 10:42 AM
Big Queries DST Daddy Photopost Pro How Do I...? 7 January 9th, 2007 11:29 PM
Slow queries - what causes them dontom Photopost Pro Bug Reports 11 November 9th, 2006 11:43 PM
queries BrandiDup Before You Buy 4 February 25th, 2006 04:16 PM


All times are GMT -5. The time now is 02:54 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0