[Monetdb-developers] blobs performance
I am working through the options for clustered file management. Normally I would expect fairly poor performance of binary file storage in a database. Hence I would favor using the file system, and sync across the machines in the cluster. Being quite different from common relational implementations, how well does Monet handle blobs of 1-10Mb? As a side question is there a support for multi-master replication? The technology looks really impressive, I hope to be able to base my future projects on MonetDB Thanks, Henrik
Dear Henrik Thank you for your interest in MonetDB. The context of your application is not evident from this short snippet so the answers are likely to be general. Henrik Vendelbo wrote:
I am working through the options for clustered file management.
Normally I would expect fairly poor performance of binary file storage
Blob implementation in MonetDB is rather traditional, which means implemented as binary strings in a table. For large binary files under the control of the DBMS I would use the more common approach to use the DBMS as in meta-data manager only. Exchange of large blobs, when time critical, would also best be done by sync across machines
in a database. Hence I would favor using the file system, and sync across the machines in the cluster. Being quite different from common relational implementations, how well does Monet handle blobs of 1-10Mb?
As a side question is there a support for multi-master replication?
no replication middleware has been released. At the kernel level there are facilities for remote query execution.
The technology looks really impressive, I hope to be able to base my future projects on MonetDB
Thanks,
thanks, Martin
Henrik
------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
participants (2)
-
Henrik Vendelbo
-
Martin Kersten