MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Olexandr Melnyk Date:April 20 2009 9:47am
Subject:Re: Does mysql support materialized views?
View as plain text  
On Mon, Apr 20, 2009 at 12:41 PM, Lin Chun <franks1984@stripped> wrote:
> Hi  Olexandr Melnyk
>
> That's to say, create the aggregation tables and update them by triggers?
> I've noticed a "update view" in Mysql , can it work under the aggretate
> operation?

You're not looking for views, you need to use normal tables.

If you will update the table by triggers, it will always be up-to-date
but query cache will be cleared on every such update.

On the other hand, if you do it periodically, data will not always be
accurate, but query cache can be used efficiently.

>
> On Mon, Apr 20, 2009 at 11:34 AM, Olexandr Melnyk <omelnyk@stripped> wrote:
>>
>> No, you will have to "emulate" them using triggers or stored procedures.
>>
>>
>>
>> --
>> Sincerely yours,
>> Olexandr Melnyk
>> http://omelnyk.net/
>
>
>
> --
> -------------------------
> Lin Chun
>



-- 
Sincerely yours,
Olexandr Melnyk
http://omelnyk.net/
Thread
Does mysql support materialized views?Lin Chun20 Apr
  • Re: Does mysql support materialized views?Krishna Chandra Prajapati20 Apr
  • Re: Does mysql support materialized views?Olexandr Melnyk20 Apr
    • Re: Does mysql support materialized views?Morten20 Apr
Re: Does mysql support materialized views?Olexandr Melnyk20 Apr