https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/LoadingBulkData
"... A much better way to do lots of inserts is to make sure the inserts are bundled into a single transaction. This can easily be done by surrounding the inserts with ašSTART TRANSACTIONšandšCOMMIT, as in:
START TRANSACTION;
INSERT INTOštablešVALUES (1, 2, 3);
...
COMMIT; ..."
Is it normal that 200 000 records insert in ~1 minute?
Can I somehow increase insert speed: disable logs or something else?
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@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@revotechs.com
šSkype: revotech.d.tikhonov
š_______________________________________________
šdevelopers-list mailing list
šdevelopers-list@monetdb.org
šhttps://www.monetdb.org/mailman/listinfo/developers-list--
Sjoerd Mullenderš
,_______________________________________________
developers-list mailing list
developers-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/developers-list