|
|
Posted by dunleav1 on 10/27/89 11:58
I can't use bulk load in my production code.
I'm creating test code to create load to tune my product.
Here's the test code I have been running to tune i/o on mssql.
This is ran from tsql and not java. Running this code locally is about
20% slower than loading Oracle via jdbc, but is a lot faster than
through jdbc.
begin transaction
declare @c int
set @c = 0
while @c <500000
begin
set @c = @c + 1
insert into insertestjd calues (@c,@c,@c,@c)
end
commit transaction
The Microsoft driver (even 1.1.1560) is slow compared to other 3rd
party jdbc drivers for Microsoft.
Navigation:
[Reply to this message]
|