Feature Requests item #2229591, was opened at 2008-11-06 14:34 Message generated for change (Settings changed) made by mr-meltdown You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&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 Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Martin Kersten (mlkersten) >Summary: SQL: 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: Niels Nes (nielsnes) Date: 2009-02-11 21:06 Message: This is a feature request ---------------------------------------------------------------------- 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=482471&aid=2229591&group_id=56967 ------------------------------------------------------------------------------ Join us December 9, 2009 for the Red Hat Virtual Experience, a free event focused on virtualization and cloud computing. Attend in-depth sessions from your desk. Your couch. Anywhere. http://p.sf.net/sfu/redhat-sfdev2dev _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
