[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.