Hey Poornima,
Are the insertions happening in a transaction? If you perform single INSERT
INTO statements in auto commit mode it will be very slow, as each of the
individual insertions will be written to disk. Bulk insert statements are
much faster. If you have to load a very large dataset, you might want to
use COPY INTO rather than individual INSERT INTO statements as well. Check
out this page for more information and performance tips:
https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/LoadingBulkData
Regards,
Mark
On Wed, Dec 2, 2015 at 6:29 PM, poornima@apakau.com
Hi,
Is there something that I need to configure. I am inserting to a local database to a table with only one covered index. I am using jdbc to write. I am getting only 30-35 insertions/sec even on a new table. This seems very low. Am I missing something ?
Regards, Poornima.
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list