Hi, After checking CPU (48 cores) none of them get over 15%, there's free memory (119Gb) and 0% reads but high WRITE activity, any idea why? Thanks, Gustavo Brian Developer -----Original Message----- From: users-list [mailto:users-list-bounces+gustavo.brian=sunhotels.net@monetdb.org] On Behalf Of users-list-request@monetdb.org Sent: lunes, 17 de agosto de 2015 12:00 To: users-list@monetdb.org Subject: users-list Digest, Vol 36, Issue 19 Send users-list mailing list submissions to users-list@monetdb.org To subscribe or unsubscribe via the World Wide Web, visit https://www.monetdb.org/mailman/listinfo/users-list or, via email, send a message with subject or body 'help' to users-list-request@monetdb.org You can reach the person managing the list at users-list-owner@monetdb.org When replying, please edit your Subject line so it is more specific than "Re: Contents of users-list digest..." Today's Topics: 1. Concurrent queries problem (Gustavo Brian) 2. Re: Concurrent queries problem (Martin Kersten) 3. Inserting in 'raw' mode?? (Vijay Krishna) ---------------------------------------------------------------------- Message: 1 Date: Sun, 16 Aug 2015 17:07:41 +0000 From: Gustavo Brian To: "users-list@monetdb.org" Subject: Concurrent queries problem Message-ID: <4A8379DA0ABDFC42B172EDB698BD76E8D46EF829@mailbox02> Content-Type: text/plain; charset="iso-8859-1" Hi, I'm using one big table a my main storage for hotel prices and I'm running queries to get the best prices for specific dates and a couple of filters. On one test I have a query scanning 30 millions rows in ~400ms but when I try to run several queries at a time monetdb hangs. I've tried creating a funnel over the database but same result. What's the best approach if I need to run 150 queries per second ? Thanks in advance, Gustavo Brian Developer SunHotels E-mail Skype Tel Fax Web Operational Office gustavo.brian@sunhotels.netmailto:gustavo.brian@sunhotels.net Gustavo.brian.sunhotels +34 871 955 649 +34 971 281 460 www.sunhotels.org SunHotels Calle Cal?at 6 Pol?gono Son Valent? 07011 Palma de Mallorca Spain

...

Winner of Grand Travel Award - Best Provider in Scandinavia << Confidential and proprietary information notice: This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.

Please preserve message history when replying to this e-mail