Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?
  1. Home
  2. Discussion Forum
  3. PHPFusion 8 Support
  4. Suspected Bugs and Errors - 8
  5. This CMS consumes a disproportionate amount of resources

This CMS consumes a disproportionate amount of resources

Asked Modified Viewed 4,764 times
Back to Forum Index Previous Topic Next Topic
Print
R
Rizado
R
Rizado 10
It's real to create protection from virus, but is unreal to create protection from idiot user. Unless AKM-74 smile .
  • Senior Member, joined since
  • Contributed 267 posts on the community forums.
  • Started 74 threads in the forums
  • Started this discussions
asked
Senior Member

This CMS is good, but consumes a disproportionate amount of resources. The reason is that the SQL-queries are unoptimized.
That's just one simple example (/administration/news.php, line 124):
$result = dbquery("SELECT * FROM ".DB_NEWS." ORDER BY news_draft DESC, news_datestamp DESC");

We see that the query selects all fields from the table, but need only 3 of them - news_id, news_subject and news_draft. Required fields we take the tens of bytes at the same time, the size of other selected fields (news_news and news_extended) may be tens of kilobytes.
In its normal form of this query should be:
$result = dbquery("SELECT news_id, news_subject, news_draft FROM ".DB_NEWS." ORDER BY news_draft DESC, news_datestamp DESC");

Such examples are quite a lot throughout the code. What do you think?
0 replies

10 posts

M
Mystikal
M
  • Junior Member, joined since
  • Contributed 11 posts on the community forums.
  • Started 1 thread in the forums
answered
Junior Member

Unfortunately I have to agree with you,I have a big website about 200k unique visitors/month,and I had to leave my webhost.Now I'm at a new webhost and he's complaining too because of my website's CPU usage.And this is very sad because this is a really great CMS,at least it does the job for me,bur c'mon guys you should really do some optimizing around this CMS.I did some optimizing around my website,and the homepage had around 70 database request per user,so we developed a little caching script and the difference is HUGE.Now I'm having only around 30 requests per user.
I really hope that some of the developers will read this topic,and they'll make some changes in future versions,or they'll give us some examples on how we could optimize our pages better.
0 replies
C
Christian
C
Best regards,
Christian Damsgaard Jørgensen.
  • Member, joined since
  • Contributed 125 posts on the community forums.
  • Started 4 threads in the forums
answered
Member

Thank you for your post - I have to agree with you. We are aware of the problem - and naturally, we are working to continuously improve PHPFusion. I am pleased to announce that v7.01 already offers a wide range of improvements in this respect - and of course we will keep up the hard work. I am sure we will manage to reduce the load further in v8 as well as we are going to improve the CMS in other respects - at least it is high on the agenda.
Edited by Christian on 17-02-2010 15:18,
0 replies
S
starefossen
S
www.postexus.com - Follow Postexus on Facebook.
  • Senior Member, joined since
  • Contributed 359 posts on the community forums.
  • Started 20 threads in the forums
answered
Senior Member

This is true Frankenstein, we have been sloppy some places in the system, generally in the admin panel but other places too. In v7.01 we are hoping to change all this and we have a very high focus on optimizations and especially MYSQL optimizations. I have optimized a lot of MySQL queries while working with PHPFusion v7.01 and I am very confident that admins will se a significant reduced load which is our goal!

Keep reporting queries which needs to be optimized and I'll fix them :D
0 replies
P
PolarFox
P
  • Veteran Member, joined since
  • Contributed 1,633 posts on the community forums.
  • Started 29 threads in the forums
answered
Veteran Member

I thought it's for fast expandability - isn't it?
I mean - new mods, file-edits etc...
0 replies
S
starefossen
S
www.postexus.com - Follow Postexus on Facebook.
  • Senior Member, joined since
  • Contributed 359 posts on the community forums.
  • Started 20 threads in the forums
answered
Senior Member

We are still not recommending users to edit core files, we haven't done anything special with PHPFusion V7.01 to make it easier to modify core files.

We have however made a new infusions_include.php file which will make development of advanced functions for PHPFusion much easier. It will hold a file upload function, image upload (with resizing), send PM, infusions settings and some more. There will be an article / news item at the MODs site about this exciting new feature when v7.01 is released!
0 replies
A
afif
A
afif 10
  • Member, joined since
  • Contributed 183 posts on the community forums.
  • Started 12 threads in the forums
answered
Member

That looks great! Can't wait for PF 7.0.1 to release!
0 replies
M
Mystikal
M
  • Junior Member, joined since
  • Contributed 11 posts on the community forums.
  • Started 1 thread in the forums
answered
Junior Member

sounds interesting :)
My website is quite heavily modified,will u give us the file names that have been changed since 7.00.07?
0 replies
H
HobbyMan
H
Just some Guy
  • Veteran Member, joined since
  • Contributed 1,486 posts on the community forums.
  • Started 91 threads in the forums
answered
Veteran Member

0 replies
M
Mystikal
M
  • Junior Member, joined since
  • Contributed 11 posts on the community forums.
  • Started 1 thread in the forums
answered
Junior Member

I saw this HobbyMan,but as far as I know they've changed alot of things since March 2009(that is the last date in the changelog)
0 replies
H
HobbyMan
H
Just some Guy
  • Veteran Member, joined since
  • Contributed 1,486 posts on the community forums.
  • Started 91 threads in the forums
answered
Veteran Member

Well, almost all files have been changedin one way or another, I doubt anyone has the time to list them here. Why not use the SVN?
0 replies

Category Forum

Suspected Bugs and Errors - 8

Labels

None yet

Statistics

  • Views 0 views
  • Posts 10 posts
  • Votes 0 votes
  • Topic users 7 members

7 participants

C
C
Best regards,
Christian Damsgaard Jørgensen.
  • Member, joined since
  • Contributed 125 posts on the community forums.
  • Started 4 threads in the forums
S
S
www.postexus.com - Follow Postexus on Facebook.
  • Senior Member, joined since
  • Contributed 359 posts on the community forums.
  • Started 20 threads in the forums
A
A
afif 10
  • Member, joined since
  • Contributed 183 posts on the community forums.
  • Started 12 threads in the forums
H
H
Just some Guy
  • Veteran Member, joined since
  • Contributed 1,486 posts on the community forums.
  • Started 91 threads in the forums
R
R
Rizado 10
It's real to create protection from virus, but is unreal to create protection from idiot user. Unless AKM-74 smile .
  • Senior Member, joined since
  • Contributed 267 posts on the community forums.
  • Started 74 threads in the forums
  • Started this discussions
P
P
  • Veteran Member, joined since
  • Contributed 1,633 posts on the community forums.
  • Started 29 threads in the forums
M
M
  • Junior Member, joined since
  • Contributed 11 posts on the community forums.
  • Started 1 thread in the forums

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet