Bugs item #2704025, was opened at 2009-03-22 20:42 Message generated for change (Tracker Item Submitted) made by skinkie You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2704025&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: SQL/Core Group: SQL CVS Head Status: Open Resolution: None Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Niels Nes (nielsnes) Summary: dynamic selectivity optimiser required Initial Comment: Using the OSM dataset I noticed there is a significant difference in the following queries: select * from way_tags where way = 9168360 and k = 'created_by'; Timer 10583.483 msec 2 rows vs select * from way_tags where k = 'created_by' and way = 9168360; Timer 331.086 msec 2 rows (this is not about hot/cold performance, the next try of the first query results in 10286.816 msec) Niels noted that this could be solved automatically using a dynamic selectivity optimiser. I first noticed this issue using delete from. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2704025&group_id=56967 ------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
