[MonetDB-users] Select * ... LIMIT takes long time
Hi, I am running the May2009 SP on Windows. I have populated a table with 40M rows and 20 columns. It takes 'SELECT * FROM table LIMIT 10' 2.5 minutes to return, in which memory and cpu consumption seems to be at a standstill. Why does it take so long? -- View this message in context: http://www.nabble.com/Select-*-...-LIMIT--takes-long-time-tp24493160p2449316... Sent from the monetdb-users mailing list archive at Nabble.com.
Alex Bo. wrote:
Hi,
I am running the May2009 SP on Windows. I have populated a table with 40M rows and 20 columns.
It takes 'SELECT * FROM table LIMIT 10' 2.5 minutes to return, in which memory and cpu consumption seems to be at a standstill. A consequence of the non-restrictive query and the bulk processing of MonetDB. The LIMIT is applied often after the result set has been produced. In this case, however, it could have been pushed down into the query plan easily.
Why does it take so long?
participants (2)
-
Alex Bo. -
Martin Kersten