How many cached queries are in memory?

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default How many cached queries are in memory?

    Is there a way to determine which queries have been cached and are in memory?

    Are there any coldfusion admin objects that have methods for viewing this?

    I need to know which queries are cached, the memory they are using, and how
    long until they expire.

    WalkWurst Guest

  2. Similar Questions and Discussions

    1. Please look at my code...Cached Queries not working
      I am running the CF MX 6.1 developer version with MySQL 4.1 on a testing machine 1. <cachedwithin>: I have a user registration page with the...
    2. Memory leak while performing standard select queries ina FOR loop
      Hi - I was wondering if someone can help me out with this issue. 1. We are pulling information from a struct/object in order to construct...
    3. Monitoring Number of Cached Queries
      Is there any way to monitor the number of queries currently being cached by cf server? I see the number of template cache pops in cfstat output,...
    4. Queries Of Queries Single Quote Problem
      When using queries of queries I'm having the following issue. Select Company_ID From qry_MyQuery Where Company_NM = 'MyString''s' <----...
    5. Seed being cached when using Rnd from asp
      Soloution: 1. Pass random number in querystring to results page. 2. On results page pass this random number in the string to the Access query 3....
  3. #2

    Default Re: How many cached queries are in memory?

    Your code reflects what queries are cached, and for how long. You can set the
    limit to how many queries will be cached before being bumped.

    The following will cache the query for 1 day:
    <cfquery name="qname" dsn="qdsn" catchedwithin="#CreateTimeSpan(1,0,0,0)#">


    tragik Guest

  4. #3

    Default Re: How many cached queries are in memory?

    That is how to create a cached query and that is not what I'm after.

    I am looking for a way to view which queries are cached, the memory they are
    using, and how long until they expire... globally for all applications.

    Perhaps using some method within the coldfusion.server.ServiceFactory.


    WalkWurst Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139