PhotoPlog

Go Back   PhotoPlog > PhotoPlog Lite > Troubleshooting & Problems
Screens Demo Purchase Download Register

Reply
Attention: Last reply in this thread was more than 18 Years ago
 
Thread Tools
  #1  
Old 02-27-2006, 01:49 AM
animehawk animehawk is offline
Green Plog
 
Join Date: Feb 2006
Posts: 15
Gallery: 0
Comments: 0
Default Huge Query count?

"Page generated in 27.76881 seconds with 233 queries "

Has anyone else had problems with huge query count? I am running 1.0.6.2. Everything else on my site loads really quick. this is the main forum load time info. "Page generated in 0.12446 seconds with 14 queries "

We've got about 1200 images with subcatagorys and all that fun stuff.

Site is www.animesanction.net

Thanks for your help.
Reply With Quote
  #2  
Old 02-28-2006, 02:07 AM
Morgan's Avatar
Morgan Morgan is offline
Head Plog
Admin
 
Join Date: Dec 2005
Posts: 5,324
Gallery: 10
Comments: 25
Default

Working on it. Watch for PhotoPlog Lite v.1.0.9. Just out of curiosity, how many main PhotoPlog categories do you have set? Can't see, no guests allowed.
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
Reply With Quote
  #3  
Old 02-28-2006, 11:48 AM
animehawk animehawk is offline
Green Plog
 
Join Date: Feb 2006
Posts: 15
Gallery: 0
Comments: 0
Default

Thanks. I've got 10 main categories and 25 sub-categories. If you need any sort of access to my site just lemme know. I'll make a user/pass for ya.
Reply With Quote
  #4  
Old 02-28-2006, 11:55 PM
Morgan's Avatar
Morgan Morgan is offline
Head Plog
Admin
 
Join Date: Dec 2005
Posts: 5,324
Gallery: 10
Comments: 25
Default

FYI: PhotoPlog Lite v.1.0.9 released. How are your query counts after upgrade?
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
Reply With Quote
  #5  
Old 03-01-2006, 02:10 AM
Tefra's Avatar
Tefra Tefra is offline
Green Plog
 
Join Date: Dec 2005
Posts: 23
Gallery: 0
Comments: 0
Default

well i don't know how many queries i had in the main part i just installed the Microstats, but with 4 Main categories and 13 subcategories i have
Page generated in 0.14671 seconds with 23 queries and after some refresh Page generated in 0.08419 seconds with 14 queries . The load difference between 1.0.8 and 1.0.9 though is remarkable

Last edited by Tefra; 03-01-2006 at 02:12 AM..
Reply With Quote
  #6  
Old 03-01-2006, 03:56 AM
Morgan's Avatar
Morgan Morgan is offline
Head Plog
Admin
 
Join Date: Dec 2005
Posts: 5,324
Gallery: 10
Comments: 25
Default

Just an FYI: the sub-categories with Lite v.1.0.9 no longer matter towards main page query count but instead are now as in this post. Lite v.1.0.9 does similar to a cron job, depending on the 'Update Categories' and 'Cache Categories' settings. When it's time for the main page categories block to be updated, there will be extra queries, up to four 'query_first' queries per main category, so it's good to keep main categories to a minimum. Otherwise, when in cache mode if you will, the main page categories block doesn't add those extra categories. This 'improvement' is on top of the removal of other useless queries, ones that were in place at some other point for whatever reason. It was time for a Lite cleanup.

If anyone has more numbers to share, I'd be glad to hear them.
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
Reply With Quote
  #7  
Old 03-01-2006, 02:29 PM
animehawk animehawk is offline
Green Plog
 
Join Date: Feb 2006
Posts: 15
Gallery: 0
Comments: 0
Default

Code:
Content visible to registered users only.
Page generated in 0.27309 seconds with 14 queries

Much better thanks.
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Query issue j3st3r Troubleshooting & Problems 5 01-15-2010 02:58 AM
Only one presale query Maxu Pre-Sale Questions 1 02-10-2007 05:09 PM


All times are GMT. The time now is 03:57 PM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.