Bugs item #2634639, was opened at 2009-02-24 20:37 Message generated for change (Comment added) made by stmane You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2634639&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: Closed >Resolution: Fixed Priority: 5 Private: Yes Submitted By: Jens Oehlschlägel (jens_oehl) Assigned to: Niels Nes (nielsnes) Summary: Extreme query execution time Initial Comment: Stefan, Query 868 out of 1207 seems to systematically hang the server (almost never ending execution) if run on 750k rows (Win32 3GB RAM). Sometimes it finishes and the next queries suffer the same, e.g. == 868: 42770.94 sec == 869: 130121.50 sec == 870: 48700.14 sec Cheers Jens MonetDB server v5.10.0 (32-bit), based on kernel v1.28.0 (32-bit oids) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved Visit http://monetdb.cwi.nl/ for further information Configured for prefix: C:\Documents and Settings\sjoerd\My Documents\src\stable\vs32\NT32 Libraries: libpcre: 7.7 2008-05-07 libxml2: 2.6.32 Compiled by: sjo...@gans Compilation: cl -GF -W3 -WX -wd4273 -wd4102 -MD -nologo -Ox Linking : cl -GF -W3 -WX -wd4273 -wd4102 -MD -nologo -Ox ---------------------------------------------------------------------- >Comment By: Stefan Manegold (stmane) Date: 2009-03-18 14:40 Message: Further tests confirmed the <= 1.5s for all three queries as I reported earlier. ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-02-28 08:11 Message: Jens, with the 1.5M dataset, these three queries now seem to run in ~3s on our 1.4GHz 2GB 32-bit Linux box, and in ~1.5s on our 2.4 GHz 2GB Win32 box. Could you please check, whether they are still problematic for you, and report if so, or close this report if not? Thanks! Stefan ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2634639&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
