*338 million rows / 54 columns table and ran queries in ms* -- WOW .. Do you mind sharing your server configuartion and the setting for mserver5.

Also what kind of queries are you firing .. ??

I find it bit slow on line level queries , something like select * from table where key = 123456

Thanks

On Sun, Jan 25, 2015 at 6:56 AM, Martin Kersten martin@monetdb.org wrote:

On 25/01/15 06:48, Gustavo Brian wrote:

...

Hi,

Hi,

thanks for the interest and appraisal.

...

I'm trying monetdb as a bigtable for calendar based queries. I've created a 338 million rows / 54 columns table and ran queries in ms. That's perfect! I wonder to see if monetdb is suitable for a search service with high traffic (several hundred request per second) and which will the best data update strategy because during the "updates/insert/copy into" actions everything gets blocked.

Queries should not be a problem, but for updates you should read and understand https://www.monetdb.org/blog/monetdb-sql-transaction-management-scheme https://www.monetdb.org/Documentation/Manuals/SQLreference/Transactions

I would like to know how cluster mode will help as well.

...

Depends on the complexity of the query and your machine specs. regards, Martin

...

Thanks, Gustavo Brian _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

---

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