MonetDB via ODBC questions
sjoerd at monetdb.org
Thu Oct 8 11:24:40 CEST 2015
See  for information about the different ways of getting data into
See  for information about concurrency control. Especially the
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?
> Best Regards,
> Daniel Tikhonov
> Programmer | Revotechs, LLC
> 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
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 473 bytes
Desc: OpenPGP digital signature
More information about the developers-list