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