[prev in list] [next in list] [prev in thread] [next in thread]
List: monetdb-users
Subject: [MonetDB-users] strange decrease in performance after some deletes
From: Majid Azimi <azimi.majid () yahoo ! com>
Date: 2012-06-25 6:29:11
Message-ID: 1340605751.87500.YahooMailNeo () web45014 ! mail ! sp1 ! yahoo ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hi guys,
I have loaded 80 million records in database.
a very complex aggregate query(multiple COUNT, SUM, AVG, GROUP BY combined) runs \
deadly fast in about 30 seconds. But after deleting 700 records performance has been \
decreased alot. the same query runs in 8 minutes now. Is this usual?
Thank you
[Attachment #5 (text/html)]
<html><body><div style="color:#000; background-color:#fff; font-family:verdana, \
helvetica, sans-serif;font-size:12pt"><div style="font-family: verdana, helvetica, \
sans-serif; font-size: 12pt; ">Hi guys,</div><div style="font-family: verdana, \
helvetica, sans-serif; font-size: 12pt; "><br></div><div><font face="verdana, \
helvetica, sans-serif" size="3">I have loaded 80 million records in \
database.</font></div><div><font face="verdana, helvetica, sans-serif" size="3">a \
very complex </font><font face="verdana, helvetica, sans-serif">aggregate \
query(multiple COUNT, SUM, AVG, GROUP BY combined) </font><font face="verdana, \
helvetica, sans-serif" size="3"> runs deadly fast in about 30 seconds. But after \
deleting 700 records performance has been decreased alot. the same query runs in 8 \
minutes now. Is this usual?</font></div><div><font face="verdana, helvetica, \
sans-serif" size="3"><br></font></div><div><font face="verdana, helvetica, \
sans-serif" size="3">Thank you</font></div></div></body></html>
------------------------------------------------------------------------------
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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic