*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