The best way to continue to insert a large amount of data via JDBC. Batch insert or stored procedure?

advertisements

I'm using Spring connecting to Sql Server 2008 R2 via JDBC.

All I need is to insert a large amount of data to a table in the database as fast as possible. I'm wondering which way is better:

  1. Use Spring batch insert mention here

  2. Create stored procedure in database and call it on Java side

Which one is better?

It depends on two things stored producer would take up the database time where as batch would take up time on the program side. so depending on what you are more concerned with it is really up to up. Me i would prefer the batch as to keep the database time free reducing errors that might occur. Hope this helps!

Related Articles

PostgreSQL: the best way to join small subsets of large tables

I am using PostgreSQL 9.3 on a Windows machine. Let's say I have a clients table with 4 million records and an orders table with 25 million records. However, I am interested in my New York clients only. There are only 5,000 New York clients who place

The best way to filter a journal by a range of dates in python

What's the best way to print log lines that match a datetime range. For example: I would like to print only lines with dates from: 2012/09/30-00:00:10 to: 2012/09/30-00:00:13 2012/09/30-00:00:08.773 log error 2012/09/30-00:00:09.034 log warning 2012/

The best way to serialize a range of hours to meaningful data

A part of my web app involves creating 'appointments' (shifts) using a drag-and-drop selector for each day. Currently, this data is serialized to something like this: 9,10,11,12,13,14,15,16,76,77,78,298,299,300,301,302,303,304, Where each number repr

What is the best way to keep your version of Rails up-to-date?

The application I'm working on was started with Rails 3.0.6, I believe 3.0.7 is available and 3.1 is just around the corner. I realise 3.1 will likely have some breaking changes, requiring a proper read through of release notes etc, before attempting