1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.3 Database Queries

Discussion in 'XenForo Questions and Support' started by Robust, Aug 30, 2014.

  1. Robust

    Robust Well-Known Member

    Image proxy was very surprising to me. Any way to speed that up? And sessions too, I'd expect them to take up less. Any alternatives or ways to speed them up?
  2. Mike

    Mike XenForo Developer Staff Member

    Are you seeing actual performance issues? Specifically with respect to the server side generation of pages.

    By definition, something is always going to be the most time consuming. It doesn't mean it's slow or a problem. If I generate a page in 100ms and there's a query that takes 5ms and 10 that take 1ms, there's more overhead from the 10 queries... but then that's disregarding the other 85% of the execution time that isn't a query at all.
  3. Robust

    Robust Well-Known Member

    Not really, I mean statistically of course there are percentages but when the overall is low the percentages don't mean as much I guess.

    Why is the query amount for proxy urls and media so high? And can sessions not be cached or stored file wise?
  4. Mike

    Mike XenForo Developer Staff Member

    Well, one slow query may well have been enough to trigger the issue. Not slow because the query caused a full table scan, but in this case, slow because the write was slow, for example.

    Unless you're seeing performance issues, I'm not sure if you can draw any real information from those stats. They're likely too abstracted.

    Regarding caching: https://xenforo.com/help/cache/
  5. Robust

    Robust Well-Known Member

    @Mike Regarding that link you gave me on caching, memcached seems to slow down page load times when I use it, not sure if that's caused by it or coincidental.

Share This Page