Hi,
I was wondering the speed difference between inserting records to database from Java as oppose to inserting records using a sql server dts package. I'm talking about 3000+ records.
See Java when inserting records to database it looks something like this:
while (recordHasNext)
{
String insertStr = "insert into table(item) values(" + valueVariable + ")";
statement.executeQuery(insertStr);
}
where as if I'm executing a dts package I would create a .bat file with the following commands:
DTSRUN.EXE /S ServerName /E /N PackageName /F FileName
And then have Java execute the batch file.
So my question is, which is faster for the amount of records I'm inserting?
thanks,