Re: very low insertion speed

Hi Poornima, 30 - 35 inserts per second is slow with autocommit on. What is your setup you said you are inserting into a local database / mserver5 instance. Also what version / environment are you using monetdb ? Regards, Brian Hood On Dec 2, 2015 7:18 PM, "poornima@apakau.com" wrote:

Hi,

I understand. I shall try bulk insert. But even with auto-commit false, I don't get any performance improvement.

Regards, Poornima.

On 12/02/2015 09:46 AM, Mark Raasveldt wrote:

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 wrote:

...

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

_______________________________________________ users-list mailing listusers-list@monetdb.orghttps://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list