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

13»

Comments

  • MinisweeperMinisweeper New
    Yeah. This forum for example uses 5 queries on a load of the discussions page. And from a quick glance, I think the actual main content is just made by one big-ass query. If you have discussion overview enabled you have 4 queries instead of that single big-ass one. I think.
  • WallPhoneWallPhone
    Yep, what mini said. 3-4 queries to generate the discussion grid isin't that bad. 15-16 however is a different story Changing the number of viewed discussions per category only changes the amount of data sent between database and Vanilla... a tiny amount of time. But assembling the discussion grid is one of the most complex queries to do, and in dovforums case, multliply that by 16 for every homepage reload. There is nothing wrong with discussion overview--just using it with many categories.
  • Thomas HeathThomas Heath
    Is there anyway to programmatically simplify this so as to limit the amount of queries?
  • TomTesterTomTester New
    edited February 2007
    FTR, I was not criticizing the add-on. Can't see a better way of doing this (other than perhaps
    some minor query caching (5 secs?) to reduce peak loads for concurrent users.

    I would however be a BIG proponent of a core-level 'code profiling ON/OFF' setting to profile
    (time) all queries and/or add-ons. There is precious little info available to review performance
    problems/requirements other than the full page load time measurements (also see previous
    topic http://lussumo.com/community/discussion/4476/ and referenced tools
    such as the vanilla timer plugin, plus firefox add-ons tamperdata & firebug)
This discussion has been closed.