Hi Shahbaz, Of course this will not solve the issue, but will you try running select sum(date), sum(time), count(ticker) from trades where date = 20120501 and time between 34200000 and 37800000; to see whether this is too slow as well? Regards Bart On 07/05/2012 11:44 AM, Stefan Manegold wrote:
On Thu, Jul 05, 2012 at 10:58:42AM +0200, Fabian Groffen wrote:
Hi Shahbaz,
On 01-07-2012 12:22:02 -0400, Shahbaz wrote:
[select sum(date), sum(time), count(ticker) from trades where date = 20120501 and time> 34200000 and time< 37800000;]
This query took 1 minute and 15 seconds! The second time I ran it, it took 1 minute and 11 seconds. Notice that count(ticker) in this query only returned 5,969,337. This query is essentially the same as the previous one, but now I am only looking to process trades between 9:30 am and 10:30 am. So this query processes 1 hours' worth of trades while previous queries process the whole day.
I cannot give any hints here, but this feels like a bug somehow. Could you open a bug for this on our bugtracker (bugs.monetdb.org), and attach the output of your fast and slow query when prefixed with "EXPLAIN"?
if possible, please attach next to the "EPLAIN"-prefixed output also the "TRACE"-prefixed output. Thanks!
Stefan
Thanks, Fabian
------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users