IM 1.4.1 Installation Upgrade Running Slow (SQL Queries)

[Dr. Bantham]

My IM 1.4.0 Installation:
[Page generation time: 0.7759s (PHP: 82% | SQL: 18%) | SQL queries: 39 | GZIP enabled | Debug on]

My IM 1.4.1 Installation:
[Page generation time: 2.5245s (PHP: 82% | SQL: 18%) | SQL queries: 606 | GZIP enabled | Debug on]

integrmod.com:
[Page generation time: 0.6848s (PHP: 74% | SQL: 26%) | SQL queries: 40 | GZIP enabled | Debug on]

Why are there 606 SQL queries on my IM 1.4.1 Installation?

[Dr. Bantham]

Am I the only one with this problem? Did anyone else get 10-20 times the number of queries as 1.4.0 after upgrading?

[tmotley]

Mine does not...

My 1.41 has 46 queries on first load of portal, 43 queries on subsequent loads, 64 queries on first load of index, and 58 on subsequent loads of the index.

Page generation times range from 0.500 to 2.500 seconds...

[Teelk]

That's very strange Dr. Bantham, there shouldn't be too many more queries then 140. What is your php and mysql version?

[Dr. Bantham]

That's very strange Dr. Bantham, there shouldn't be too many more queries then 140. What is your php and mysql version?

PHP Version 4.4.4
MySQL Version 4.1.21

[Teelk]

Ok, I've got an idea. It could be that your CHMODs have reset and it's pulling all info about the forum from the DB instead of the includes/def_xxxx.php files. Check all your CHMODs and retest.

[Dr. Bantham]

Ok, I've got an idea. It could be that your CHMODs have reset and it's pulling all info about the forum from the DB instead of the includes/def_xxxx.php files. Check all your CHMODs and retest.

I suspect that you might be onto something here. I'll check these tomorrow and report back.

[Dr. Bantham]

Ok, I've got an idea. It could be that your CHMODs have reset and it's pulling all info about the forum from the DB instead of the includes/def_xxxx.php files. Check all your CHMODs and retest.

Excellent call, Teelk. My SQL queries did fall back down to 50 in lieu of 606. However, the page load did not increase in speed significantly (my IM 1.4.0 installation in the root directory runs consistently under the sub-second mark). That does not make sense. I re-compiled the cache to be certain, but I am still in the 2-2.5 second range for the IM 1.4.1 upgraded installation which runs in a subdirectory.

[Page generation time: 2.3432s (PHP: 91% | SQL: 9%) | SQL queries: 50 | GZIP enabled | Debug on]