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: Open Resolution: None 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-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 ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
