Re: very low insertion speed

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 mailto:poornima@apakau.com mailto: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 mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

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