Bugs item #2229591, was opened at 2008-11-06 14:34 Message generated for change (Comment added) made by mlkersten You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2229591&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) >Assigned to: Martin Kersten (mlkersten) Summary: [Performance] materialize aggregate results in a view Initial Comment: Currently it looks like any operation on a view is stacked; the view-query is executed along the query on the view. I wonder, especially for aggregated values such as created with GROUP BY, if it isn't a better solution to materialize them instead of recalculating them. ---------------------------------------------------------------------- >Comment By: Martin Kersten (mlkersten) Date: 2008-11-19 08:38 Message: A test file has been added to test/BugTracker ---------------------------------------------------------------------- Comment By: Martin Kersten (mlkersten) Date: 2008-11-19 08:30 Message: This can be considered a bug, because the implementation was meant to remove all such duplicate subqueries. A new commonterm optimizer has been created, but will be checked in after the SIGMOD deadline to avoid possible interference with recycler experimentation. ---------------------------------------------------------------------- Comment By: Stefan de Konink (skinkie) Date: 2008-11-18 16:22 Message: Right comment to wrong bug? ---------------------------------------------------------------------- Comment By: Martin Kersten (mlkersten) Date: 2008-11-18 16:09 Message: Observation confirmed. The commonTerm optimizer should have removed the duplicate code. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2229591&group_id=56967 ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
