117 Queries on Photopost uploadphoto?

macuser · January 22nd, 2013, 10:11 AM

Hi,

I've just run the debug und show me a lot of queries

uploadphoto.php = Page generated in 0.13343 seconds with 117 queries

gallery-home = Page generated in 0.05362 seconds with 24 queries

showphoto with 0 comments = Page generated in 0.02895 seconds with 31 queries
showphoto with 5 comments = Page generated in 0.04947 seconds with 37 queries
showphoto with 6 comments = Page generated in 0.06739 seconds with 44 queries
showphoto with 10 comments = Page generated in 0.06535 seconds with 42 queries
categorie with 15 thomnals = Page generated in 0.06902 seconds with 20 queries
member gallery = Page generated in 0.04001 seconds with 31 queries

That is definitely not normal, how can I fix it?

Photopost Version = 8.23

Thanks
macuser

Chuck S · January 22nd, 2013, 10:46 AM

What ever it is not coming from our application.

Our upload page has like 26 queries when you figure out what options you want to load etc

A community photo gallery - My Photo Gallery

Page generated in 0.33307 seconds with 26 queries

That is from the upload page

Anything from 20 to 40 some queries would be considered normal depending on the features you turn on or off.

I definately would need more direct examples. Need to see what queries are listed as being ran.

macuser · January 22nd, 2013, 11:59 AM

All the queries are definitively from your application

Gallery Home with 32 categories and a lot of thumbnails generate only 23 queries
uploadphoto generates 117 and somtimes 119 queries, another application is vB header und footer

I´ve downloaded your application again today and uploaded all the files - nothing changed.

Chuck S · January 22nd, 2013, 12:02 PM

I showed you a very specific example there are only 26 queries on my site.

Your not giving me anything to work with here. What are the queries? All the queries are definately listed that our application uses so I need to see that. Your number of queries will vary depending on options thats for sure but not 117 that I would think of unless there is some plugin mod?

If you want me to comment you need to list a url login and have that debug information showing.

PS. Is this the site?

http://www.macuser.de/galerie

Chuck S · January 23rd, 2013, 11:41 AM

You can send data through the contact us link privately if you want.

I was waiting for a response yesterday guess you where busy. I can not respond further on your issue without actually seeing the issue and the queries generated. That obviously would require an admin login.

I take it you have set this line in pp-inc.php to 1 or 2 as that is the only way our page prints that debug info.

Code:

Content visible to verified customers only.

Number 2 shows the debug information about our script with the queries our script runs.

I am beginning to think your talking vbulletin debug thing not ours.

Chuck S · January 24th, 2013, 11:42 AM

I checked out your site and the only debug thing I see is the vb debug is on.

Edit your pp-inc.php and set the line I noted above to 2 not 0 and make sure debug is is on in the photopost admin. That will show you precisely every sql query that is running in our application and will even print the list of queries.

macuser · January 27th, 2013, 07:48 AM

Quote:

Originally Posted by Chuck S

I checked out your site and the only debug thing I see is the vb debug is on.

Edit your pp-inc.php and set the line I noted above to 2 not 0 and make sure debug is is on in the photopost admin. That will show you precisely every sql query that is running in our application and will even print the list of queries.

Thank you, I changed it to 2

Why uploadphoto.php displays still all the album categories?
Every deactivated album category generates 1 query. I can delete empty the albums.
We deactivate albums for the user about 8 years ago, but we did not delete the albums.

My Setting
Photopost Admin CP ->Allow users to create Personal Albums? = No

What is the best way to remove the albumcats to display in uploadphoto.php?

uploadphoto.tmp is already done

We use only user statistics plugin
http://www.photopost.com/forum/photo...tatistics.html

macuser · January 27th, 2013, 07:49 AM

the list of queries

uploadphoto

Code:

Content visible to verified customers only.

macuser · January 27th, 2013, 07:54 AM

members gallery

Code:

Content visible to verified customers only.

macuser · January 27th, 2013, 07:56 AM

showphoto

Code:

Content visible to verified customers only.

Chuck S · January 27th, 2013, 09:53 AM

Macuser admin will see everything indeed so this is nothing your users see.

If you have tons of personal albums which you as admin are allowed to use then you will see everything. Members however will not see everything.

They only see there stuff.

I am not sure why there is a get_userinfo for every album owner that seems odd.

You can delete any albums if they are empty and your not using them sure.

Chuck S · January 27th, 2013, 07:41 PM

The queries are normal and because you are admin. My suggestion is to delete any albums or categories you do not want.

basically as admin since you see everything the queries running are to grab the category and albums list. Since we need to show who's albums they are the queries to grab the users info is needed.

Like I said though regular users would not see this.