Page 1 of 1

IM 1.4.1 Installation Upgrade Running Slow (SQL Queries)

PostPosted: Sat Jan 20, 2007 9:45 am
Author: 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?

Re: IM 1.4.1 Installation Upgrade Running Slow (SQL Queries)

PostPosted: Sun Jan 21, 2007 5:25 am
Author: 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?

PostPosted: Sun Jan 21, 2007 7:43 am
Author: 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...

Re: IM 1.4.1 Installation Upgrade Running Slow (SQL Queries)

PostPosted: Mon Jan 22, 2007 7:44 pm
Author: Teelk
That's very strange Dr. Bantham, there shouldn't be too many more queries then 140. What is your php and mysql version?

Re: IM 1.4.1 Installation Upgrade Running Slow (SQL Queries)

PostPosted: Mon Jan 22, 2007 8:42 pm
Author: Dr. Bantham
"Teelk";p="20142" wrote: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

Re: IM 1.4.1 Installation Upgrade Running Slow (SQL Queries)

PostPosted: Mon Jan 22, 2007 8:44 pm
Author: 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.

Re: IM 1.4.1 Installation Upgrade Running Slow (SQL Queries)

PostPosted: Mon Jan 22, 2007 9:02 pm
Author: Dr. Bantham
"Teelk";p="20152" wrote: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.

Re: IM 1.4.1 Installation Upgrade Running Slow (SQL Queries)

PostPosted: Wed Jan 24, 2007 5:31 pm
Author: Dr. Bantham
"Teelk";p="20152" wrote: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]