Bugs item #2619622, was opened at 2009-02-20 12:45
Message generated for change (Comment added) made by stmane
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2619622&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 "stable"
Status: Open
Resolution: None
Priority: 5
Private: Yes
Submitted By: Jens Oehlschlägel (jens_oehl)
Assigned to: Niels Nes (nielsnes)
Summary: Painpoints under Win32
Initial Comment:
This is testing our first 'private' bugreport:
With 600k rows, these are the two most critical statements in the series of
1207 SQLs provided to Stefan and Sjoerd.
# 859 (20 sec with 600k)
SELECT KX, PostingYear, PostingStep, SUM(num1) as sNum1, SUM(den1) as sDen1
FROM ( SELECT MIN(1) as PostingStep, PostingYear, Min('X') as KX, SUM(DT_D02)
as num1, MIN(0) as den1 FROM voc.q_SourceKPIReports WHERE ((PostingYear>=2005)
AND (PostingYear <= 2006)) GROUP BY PostingYear) as sSub3 GROUP BY KX,
PostingYear, PostingStep;
# 983 (point of crash with 600k, works with freshly restarted server)
SELECT KX, PostingYear, PostingStep, SUM(num1) as sNum1, SUM(den1) as sDen1
FROM ( SELECT Postingsemi as PostingStep, PostingYear, Min('X') as KX,
SUM(DT_D02) as num1, MIN(0) as den1 FROM voc.q_SourceKPIReports WHERE
(((PostingYear>2005 AND PostingYear<2006) OR (PostingYear=2005 AND
Postingsemi>=1) OR (PostingYear=2006 AND Postingsemi<=2))) GROUP BY
PostingYear, Postingsemi) as sSub3 GROUP BY KX, PostingYear, PostingStep;
----------------------------------------------------------------------
>Comment By: Stefan Manegold (stmane)
Date: 2009-02-24 17:51
Message:
please ignore my previous accidental comment
----------------------------------------------------------------------
Comment By: Stefan Manegold (stmane)
Date: 2009-02-24 17:49
Message:
added original query as test BatAppendUndefined.SF-2633634.sql
added modified query as test BatAppendUndefined.SF-2633634_OK.sql
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2619622&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
