miniBB ® miniBB®
miniBB Support Forums
 | Forums | Register | Reply | Search | Statistics | Manual |
Specific miniBB Support Forums / Specific /   

1 million topics: 16 seconds to load page.

Page  Page 2 of 2:  « Previous  1  2  
Author tom322
Registered
#16 | Posted: 4 Feb 2007 18:33 
For me personally it would make sense to try to install the latest version of the core forum script (without any custom modifications) and start from there.. Then you could be adding modifications and after each modification you could test it and have a chance to find what exactly causes the problem.

Author Paul
Lead Developer
#17 | Posted: 5 Feb 2007 03:55 
For me personally it would make sense to try to install the latest version of the core forum script (without any custom modifications) and start from there

Yes, I would do recommend the same.

You did some custom changes and afterall it's difficult to say what exactly could be the reason. As you see default POSTS table works fine.

Author Samuel Vignoli
Registered
#18 | Posted: 8 Feb 2007 07:12 
I couldn't restart it yet but today I tried something different... just to share:

without the "where forum_id"
SELECT topic_id
FROM forumlv_topics
ORDER BY topic_last_post_id DESC
LIMIT 500 , 50
50 rows in set (0.02 sec)

SELECT topic_id
FROM forumlv_topics
ORDER BY sticky DESC,topic_last_post_id DESC
LIMIT 550 , 50
50 rows in set (2.95 sec)


Maybe too many repeated values (sticky=0 and forum_id=1) is the cause... I'll keep you guys informed... thanks =)

Page  Page 2 of 2:  « Previous  1  2 
Specific miniBB Support Forums / Specific / 1 million topics: 16 seconds to load page. Top

Your Reply Click this icon to move up to the quoted message

 Short link for this topic:

 ?
Only registered users are allowed to post here. Please, enter your username/password details upon posting a message, or register first.


Before posting, make sure your message is compliant with our forum posting rules. If not, it may be locked or deleted with no explanation.
 
 
miniBB Support Forums Powered by Forum Software miniBB ® Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contacts
Proceed with the Captcha add-on: protect your miniBB-forums from the automated spam and flood.
Captcha Addon for miniBB