Blog Documentation Book a Demo
Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Web host complaining about CPU load

2

Comments

  • y2kbgy2kbg New
    i vote jazzman and maybe have a star next next to it like green for jazzman, red for mark as to who it has been approved and tested by. If something is mark and Jazzman approved you could be assured of no problems. Maybe build in a bug submission system into the addons and maybe a browswer incompatibility note on each extension, being submitted by s and then have the bug confirmed by the author or a "approve" extension moderator. Maybe throw out the old extension into a recycle bin until they become efficient.

    Sorry for the rant...
  • bjrnbjrn
    I think asking Jazzman and Mark to "approve" all extensions is really over the top. However, some kind of informal peer review of code might be good. Just asking people to look at the code when you've made a new extension might be a good way to make extensions better.
  • y2kbgy2kbg New
    well i mean like once they get 500 downloads or something they should be looked over and "approved" by someone that has good php and is well known here. this includes, but is DEFINITELY not limited to Jazzman and Mark.
  • MinisweeperMinisweeper New
    I agree completely that it would be an excellent idea but it does rely very heavily on the suitably skilled people being prepared to do so...and I dont believe it's any secret that Mark and Jazzman (and others) are pretty short of free time. I'm at a point in my life where I'm positively trying to maximise the amount of free time I have although at the same time I'm trying to employ it as productively as possible (two interesting things to try and juggle!) - unfortunately I'm not as skilled in PHP as I aught to be and I'm also confusingly lazy.
  • jimwjimw
    All of you do a tremendous job for the Vanilla community. In an ideal world, we would have time to do all the things we want. But sadly this is not one.
  • adrian.adrian. ✭
    we, all just need to write better extensions. hopefully soon, I will be implementing vanilla for a social network I'm building. hopefully a side effect of this will be a quality extension or two
  • jacmgrjacmgr
    Curious about the end result of the changes. Has your hosting provider given you new statistics since the changes you made?
  • StashStash ✭
    I'd be interested in this as well since I'm on shared hosting.
  • dovforumsdovforums
    The admin will get back to me probably tomorrow to let me know if she sees a decrease in CPU load. Hopefully the removal of "Discussion Overview" and reducing the number of discussions to 20 per page will help.
  • ADMADM
    Yeah I think you'll be ok now. You had a LOT of forums and as such tonnes of queries everytime someone viewed the front page.

    That's the ultimate way to increase load on a server.

    Trust me I've had webhosts contact me many times about the exact same thing and almost 95% of the time it was due to mods which used a tonne of queries. This isn't Jazzman's fault of course (:p) as unlike Jazzman's kickass coding the mods that took my server were terrible.
  • ADMADM
    Oh yeah another thing, I don't think you really needed to reduce the topics per page down to 20. I think you would be fine with what you had unless it was something like 50+.
  • dovforumsdovforums
    Great news! Removing the Discussion Overview extension has brought resource usage down to acceptable levels. My web host is happy! Phew. Thanks for the help everybody!
  • TomTesterTomTester New
    edited February 2007
    Eeeeh, did anyone else notice the irony here... (the culprit in question, discussion overview plugin, was actually written by Jazzman? ;-)
  • y2kbgy2kbg New
    haha wow thats funny
  • MinisweeperMinisweeper New
    Why's that ironic?
  • KrakKrak New
    y2kbg"i vote jazzman and maybe have a star next next to it like green for jazzman, red for mark as to who it has been approved and tested by. If something is mark and Jazzman approved you could be assured of no problems."

    Thats why.
  • MinisweeperMinisweeper New
    There's nothing wrong with the extension, though. The SQL queries could perhaps be optomised slightly (not being a SQL expert i wouldnt know) but realistically anything which makes a significantly higher number of SQL queries (which i assume is unavoidable since it's getting a load more data) is bound to cause performance issues when used on a large scale...
  • WandererWanderer
    I would have thought Discussion Overview would be making less queries?
    I have mine set to 4 discussions in each category (only 4 categories).
    Surely that's less queries than "all discussions"?

    Posted: Friday, 16 February 2007 at 1:58PM (AEDT)

  • KrakKrak New
    I found it quite humorous
  • DinoboffDinoboff
    I suppose it has to do one query for each category.
This discussion has been closed.