Feature Requests item #2229591, was opened at 2008-11-06 13:34 Message generated for change (Comment added) made by nielsnes 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: [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: Niels Nes (nielsnes) Date: 2009-02-11 20:06 Message: This is a feature request ---------------------------------------------------------------------- Comment By: Martin Kersten (mlkersten) Date: 2008-11-19 07:38 Message: A test file has been added to test/BugTracker ---------------------------------------------------------------------- Comment By: Martin Kersten (mlkersten) Date: 2008-11-19 07: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 15:22 Message: Right comment to wrong bug? ---------------------------------------------------------------------- Comment By: Martin Kersten (mlkersten) Date: 2008-11-18 15: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 ------------------------------------------------------------------------------ Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
