Board index is very slow

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
User avatar
Galaxy21
Registered User
Posts: 111
Joined: Mon Aug 13, 2007 12:03 am
Location: Dresden, Deutschland
Contact:

Board index is very slow

Post by Galaxy21 » Sat Jul 25, 2009 3:40 pm

Support Request Template
What version of phpBB are you using? phpBB 3.0.5
What is your board's URL? http://localhost
Who do you host your board with? My own server
How did you install your board? I used the download package from phpBB.com
Is your board a fresh install or a conversion? Conversion from phpBB2
Do you have any MODs installed? Yes
What MODs do you have installed? Some...
When did your problem begin? After conversion from phpBB2
Please describe your problem.
The Board index is very slow due to this SQL query:

Code: Select all

SELECT f.*, ft.mark_time, t.topic_title, t.topic_id, t.topic_last_post_id FROM (phpbb_forums f) LEFT JOIN phpbb_forums_track ft ON (ft.user_id = 2 AND ft.forum_id = f.forum_id) LEFT JOIN phpbb_topics t ON (f.forum_last_post_id = t.topic_last_post_id AND t.topic_moved_id = 0) ORDER BY f.left_id
I have the board running on 2 systems. On my local server and on my webserver which hosts my current (soon to be converted) old phpBB2 board. On both systems I run the same files and DB content. So files and database are the same. The difference is in the server software and hardware. Locally I run a PHP 5.2.9 with MySQL 5.0.37 while on the webserver is (unfortunately) a PHP 4.4.7 and MySQL 4.1.22 running. The hardware on my local test system is slower then the one on my webserver. However, locally the Board-Index takes about 0.3 - 0.5 seconds for the page while on the webserver it takes about 4-6 full seconds for the same page. The SQL-Report shows, that it is the query above, which takes the longest - but only on the webserver and only on the Board-index.
Could this be related to the old server software (PHP 4.4.7 & MySQL 4.1.22)?
I can't update it until the board is converted, because my old board doesn't run with PHP5.
What styles do you currently have installed? prosilver, subsilver2
What language(s) is your board currently using? en, de
Which database type/version are you using? MySQL 4 / 5
What is your level of experience? Comfortable with PHP and phpBB
Generated by SRT Generator ($Rev: 3036 $)

User avatar
Galaxy21
Registered User
Posts: 111
Joined: Mon Aug 13, 2007 12:03 am
Location: Dresden, Deutschland
Contact:

Re: Board index is very slow

Post by Galaxy21 » Tue Jul 28, 2009 2:20 pm

Any ideas on this?

Locked

Return to “[3.0.x] Support Forum”