On 16/08/15 19:07, Gustavo Brian wrote:

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 ? The first question to answer to yourself is if the system CPU load is nearing 100%. Then assuming that your database itself fit in your RAM, there is no room left for more parallel processing without hurting yourself performancewise or 'freezing' the box.

Run experiments with 1,2,3,4,5,...., concurrent queries to determine the best level. regards, Martin

Thanks in advance,

*/Gustavo Brian/**//*

/Developer/

*SunHotels***

*E-mail*

*Skype*

*Tel*

*Fax*

*Web*

*Operational Office*

_gustavo.brian@sunhotels.net mailto: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

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list