Author |
Message |
JLA Board Member
Joined: 30 Apr 2009
Posts: 451 Location: U.S.A
|
Posted: 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
|
Posted: 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 IL • Mac 512K Blog • Mac GUI |
|
Back to top |
|
|
JLA Board Member
Joined: 30 Apr 2009
Posts: 451 Location: U.S.A
|
Posted: 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
|
Posted: 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
|
Posted: 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
|
Posted: 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
|
Posted: 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 . 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 |
|
|
|