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!