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