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

Gustavo.brian.sunhotels

+34 871 955 649

+34 971 281 460

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