LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  JDBC Store performance issues

    Employee
    Posted 09-18-2012 01:42

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: mgreenbank

    Hi,

    I've been using the 'JDBC store' node to insert data into an SQL Server (2008 R2) database, I've managed to get it all working but I'm only able to insert approx. 17,000 records every 30mins, upon investigate it led me to believe that I needed to add the additional line to the connection string 'EnableBulkLoad=true;BulkLoadBatchSize=10000', this doesn't seem to work, do I need to configure/specify anything else to enable bulk load?


    Thanks

    Matt


  • 2.  RE: JDBC Store performance issues

    Employee
    Posted 09-18-2012 14:57

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rboccuzzi

    Matt, it looks like this thread describes what you are looking for?

    Cheers
    Rich