Hi, which version of MonetDB are you running on which OS? How many tuples (rows) does your table have? Of what type are the columns used in your query? Could you run the query twice and compare/report the timings? Could you run the following queries and report their result and runtime? Select count(*) from historical; Select count(userid) from historical; Select count(distinct userid) from historical; Select count(*) from historical where gender='men'; Select count(*) from historical where brand='puma'; Select count(*) from historical where gender='men' and brand='puma'; Select count(userid) from historical where gender='men' and brand='puma'; Select count(distinct userid) from historical where gender='men' and brand='puma'; Could you run the following queries and report their runtime? select sum(mrp)/sum(noOfItems) from historical where gender='men' and brand='puma'; select sum(mrp)/sum(orderCount) from historical where gender='men' and brand='puma'; select sum(revenue) from historical where gender='men' and brand='puma'; select sum(orderCount) from historical where gender='men' and brand='puma'; select sum(noOfItems) from historical where gender='men' and brand='puma'; select sum(returnCount) from historical where gender='men' and brand='puma'; select sum(rtoCount) from historical where gender='men' and brand='puma'; select sum(0) from historical where gender='men' and brand='puma'; select sum(tDiscountPer) from historical where gender='men' and brand='puma'; select sum(cDiscountPer) from historical where gender='men' and brand='puma'; Best, Stefan ----- On Nov 7, 2016, at 8:14 AM, Rajendra Bhat rajhalkere@gmail.com wrote:
Hi team,
I am running monetdb on 16 core processor and 30gb ram.
I have table around 54 fields. gzip compressed csv size is around 6.5 GB.
query will take around 6 min. please suggest tuning options.
query: Select count(distinct userid),sum(mrp)/sum(noOfItems),sum(mrp)/sum(orderCount),sum(revenue),sum(orderCount),sumnoOfItems),sum(returnCount),sum(rtoCount),sum(0),sum(0),sum(tDiscountPer),sum(cDiscountPer) from historical where gender='men' and brand='puma' Thanks and Regards
Rajendra Bhat
-- Thanks and Regards
Rajendra Bhat
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |