Professional Web Applications Themes

'Cached' Views - MySQL

Hi all, I vaguely remember reading something about creating a view where the result was stored on disk. Whenever the referenced data changed the view results were updated, and each time the view is accessed, the cached version is used. From memory, this was equivalent to setting up BEFORE/AFTER UPDATE triggers. Trouble is, I can't seem to find anything about it anymore. Was I mistaken, and if not, can someone give me a nudge in the right direction? Cheers, --...

  1. #1

    Default 'Cached' Views

    Hi all,

    I vaguely remember reading something about creating a view where the result was stored
    on disk. Whenever the referenced data changed the view results were updated, and each
    time the view is accessed, the cached version is used.

    From memory, this was equivalent to setting up BEFORE/AFTER UPDATE triggers.

    Trouble is, I can't seem to find anything about it anymore. Was I mistaken, and if not,
    can someone give me a nudge in the right direction?

    Cheers,

    --

    Murdoc Guest

  2. #2

    Default Re: 'Cached' Views

     
    [...]

    Check these links:

    http://x4.olap4all.com/x4/X4-MaterializedViews.pdf
    http://x4.olap4all.com/x4/X4-InstallationGuide.pdf


    Regards
    Dimitre


    Radoulov, Guest

  3. #3

    Default Re: 'Cached' Views

    Radoulov, Dimitre wrote:
     
    > [...]
    >
    > Check these links:
    >
    > http://x4.olap4all.com/x4/X4-MaterializedViews.pdf
    > http://x4.olap4all.com/x4/X4-InstallationGuide.pdf
    >
    >
    > Regards
    > Dimitre[/ref]

    Thanks, Dimitre. I thought what I read was done in MySQL natively, though.

    --

    Murdoc Guest

  4. #4

    Default Re: 'Cached' Views


    "Murdoc" <com> wrote in message
    news:connect.com.au...
    Radoulov, Dimitre wrote:
     
    > [...]
    >
    > Check these links:
    >
    > http://x4.olap4all.com/x4/X4-MaterializedViews.pdf
    > http://x4.olap4all.com/x4/X4-InstallationGuide.pdf[/ref]

     [/ref]

    You could do it with procedures/triggers, but it's like reinventing the
    wheel.

    http://pure.rednoize.com/2005/10/26/materialized-views-in-mysql/


    Regards
    Dimitre


    Radoulov, Guest

Similar Threads

  1. Cached query
    By kruse in forum Coldfusion Database Access
    Replies: 2
    Last Post: September 29th, 09:32 AM
  2. Cached Page
    By dengibtsicherned in forum Coldfusion Server Administration
    Replies: 0
    Last Post: July 6th, 02:21 PM
  3. Seed being cached when using Rnd from asp
    By Bill Morrison in forum ASP Database
    Replies: 3
    Last Post: February 12th, 02:28 AM
  4. Replies: 4
    Last Post: July 8th, 07:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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