Results 1 to 2 of 2

Thread: Query Caching

  1. #1
    Join Date
    Feb 2002
    San Francisco, CA

    Unanswered: Query Caching

    Has anyone had experience of Query Caching (>v4.0.1)? I have heard both good and bad things about the performance gains, but was wondering if any of you lot knew first hand?

  2. #2
    Join Date
    Feb 2001
    NC, USA
    I've got it enabled on this forum. The benefits will vary depending on the application. The thing to remember is that each time data is commited to the table, the cache for that table is flushed. So for read-only tables, the benefit is huge.

    In the case of this forum, there's probably a 50% hit ratio overall. This seems pretty poor, but it's a little misleading as most of the tables enjoy a 90+% hit ratio. The session table is constantly updated and that drags the overall hit ratio down.

    All you can do is try it. It's unlikely that many applications will see a performance decrease with it enabled.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts