MonetDB via ODBC questions

Sjoerd Mullender sjoerd at monetdb.org
Thu Oct 8 11:24:40 CEST 2015


See [1] for information about the different ways of getting data into
MonetDB.
See [2] for information about concurrency control.  Especially the
second section.

[1]
https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/LoadingBulkData
[2] https://www.monetdb.org/blog/monetdb-sql-transaction-management-scheme

On 08/10/15 11:00, d.tikhonov at revotechs.com wrote:
>  
> 
> Good day.
> 
> I use MonetDB in my .net project via odbc driver. And I have some
> questions, maybe you can help me.
> 
> 1. What is the best practice for inserting data via INSERT statements?
> 
> In MonetDB exists operation for bulk data loading (COPY INTO) but it
> requires file or stream and this solution doesn't suit my project.
> 
> I tried to use START TRANSACTION; ... COMMIT; but my best result was 220
> 000 records in 1 minute.
> 
> How can I insert data via INSERT the fastest way?
> 
> 2. Does monetDB support multi thread insert, update, delete via odbc?
> When I tried to test it I have got ODBCException: general exception.
> 
> How does MonetDB handles concurrent requests?
> 
> Thanks!
> 
> -- 
>  
>  
> Best Regards,
> Daniel Tikhonov
>  
> Programmer | Revotechs, LLC
> Revotechs.com
> Mobile: +375 (33) 341-87-54
> Email: d.tikhonov at revotechs.com
> Skype: revotech.d.tikhonov
>  
> 
> 
> _______________________________________________
> developers-list mailing list
> developers-list at monetdb.org
> https://www.monetdb.org/mailman/listinfo/developers-list
> 


-- 
Sjoerd Mullender

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: OpenPGP digital signature
URL: <http://www.monetdb.org/pipermail/developers-list/attachments/20151008/c15adb80/attachment.sig>


More information about the developers-list mailing list