Re: [MonetDB-users] Select * ... LIMIT takes long time

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?