On Mon, Apr 20, 2009 at 12:41 PM, Lin Chun <franks1...@gmail.com> 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 <omel...@gmail.com> 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/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
