phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

Poll - Queries per page


 
Search this topic... | Search phpBB2 Discussion... | Search Box
Register or Login to Post    Index » phpBB2 Discussion  Previous TopicPrint TopicNext Topic
Author Message
JLA
Board Member



Joined: 30 Apr 2009

Posts: 451
Location: U.S.A


flag
PostPosted: Fri Jun 21, 2013 6:09 pm 
Post subject: Poll - Queries per page

Just curious for your PHPBB2 users out there - how many (typical/average) queries, execution time and php memory per page are you running for?

Index
Viewforum
Viewtopic

_________________
http://www.jlaforums.com
Back to top
Dog Cow
Board Member



Joined: 18 Nov 2008

Posts: 378


flag
PostPosted: Tue Jul 02, 2013 5:24 pm 
Post subject: Re: Poll - Queries per page

Forum index in 0.056s with 5 queries. Memory Usage: 1.89 MB
Viewforum in 0.057s with 8 queries. Memory Usage: 2.12 MB (20 topics per page)
Viewtopic in 0.066s with 10 queries. Memory Usage: 2.78 MB (15 posts per page)

All of these are using the query cache while logged in. The memory for viewtopic can vary widely as a factor of how much BBCode is being used in the posts. I have posts greater than a certain length get cached in HTML so I can skip the automatic-URL, smiley, and BBCode processing steps.

_________________
Moof!
Lincoln's Tomb, Oak Ridge Cemetery, Springfield ILMac 512K BlogMac GUI
Back to top
JLA
Board Member



Joined: 30 Apr 2009

Posts: 451
Location: U.S.A


flag
PostPosted: Sat Jul 13, 2013 12:27 pm 
Post subject: Re: Poll - Queries per page

Dog Cow wrote:
Forum index in 0.056s with 5 queries. Memory Usage: 1.89 MB
Viewforum in 0.057s with 8 queries. Memory Usage: 2.12 MB (20 topics per page)
Viewtopic in 0.066s with 10 queries. Memory Usage: 2.78 MB (15 posts per page)

All of these are using the query cache while logged in. The memory for viewtopic can vary widely as a factor of how much BBCode is being used in the posts. I have posts greater than a certain length get cached in HTML so I can skip the automatic-URL, smiley, and BBCode processing steps.


Thanks

_________________
http://www.jlaforums.com
Back to top
nostro
Board Member



Joined: 16 Jul 2012

Posts: 54


flag
PostPosted: Wed Oct 22, 2014 3:20 am 
Post subject: Re: Poll - Queries per page

A forum with 175,000 posts (sorry, no info about number of queries):

Index (time - memory - peak memory):
0.031 - 1.19 MiB - 1.65 MiB

Viewforum:
0.058 - 1.39 MiB - 1.53 MiB (50 topics per page)

Viewtopic:
0.059 - 1.39 MiB - 1.78 MiB (15 posts per page)

No post caching mod installed, but at least it caches cats/forums info, forum moderators, ranks, birthdays and smilies... I thought that bbcodes also got cached but apparently I forgot about it, I should do it soon.
Back to top
JLA
Board Member



Joined: 30 Apr 2009

Posts: 451
Location: U.S.A


flag
PostPosted: Sat Nov 15, 2014 2:15 am 
Post subject: Re: Poll - Queries per page

Thanks for the info
_________________
http://www.jlaforums.com
Back to top
Vendethiel
Board Member



Joined: 26 Oct 2014

Posts: 251



PostPosted: Sat Nov 15, 2014 10:55 am 
Post subject: Re: Poll - Queries per page

On EzArena, this is what I get (mod list is quite big but it's on an almost-empty forum, I just filled 3 forums with 3 pages worth of topic, each with 3 pages worth of posts)

Index
Page generated in 0.05948 seconds || SQL queries: 4

Viewforum
Page generated in 0.05687 seconds || SQL queries: 3

Viewtopic
Page generated in 0.09031 seconds || SQL queries: 5


One day, I'll remove the SIDs and I'll get -1 query.. One day...

_________________
Developer on EzArena, the ADR premod.
Developer on Icy Phoenix, the phpBB hybrid cms.
Developer on IntegraMOD, the full-featured premod.
Help me archive premods on github! (fixed for recent PHPs).
Back to top
Vendethiel
Board Member



Joined: 26 Oct 2014

Posts: 251



PostPosted: Sat Nov 22, 2014 8:13 am 
Post subject: Re: Poll - Queries per page

So, I actually did that and got my index page to 0 queries (with a cache expiring every 5 minutes for the "online" list, and a posting cache for the recent topics thing). It's just made my "current users online" tracking worse, actually icon_razz.gif. Not much faster. But probably easier on the SQL server...
_________________
Developer on EzArena, the ADR premod.
Developer on Icy Phoenix, the phpBB hybrid cms.
Developer on IntegraMOD, the full-featured premod.
Help me archive premods on github! (fixed for recent PHPs).
Back to top
Display posts from previous:   
Register or Login to Post    Index » phpBB2 Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 4 Hours
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0404 seconds using 16 queries. (SQL 0.0093 Parse 0.0007 Other 0.0304)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo