2005/10/20, Heikki Tuuri <[EMAIL PROTECTED]>: > Andrew, > > how about using triggers to recompute materialized views? A challenge is to > write an automatic program that can compute the required triggers based on > the view definition. The materialized view would be a normal table. Triggers > would update it. > > Regards,
Better, mark this view (or particular rows if it's not too expensive) as "dirty" and recompute it only on access, you may spare few cycles... -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]