insertion delay

• varunfilim

  Mr or Mrs. 500

  Points: 564

  More actions

  October 30, 2009 at 10:48 pm

  #103850

  I hav a java application which using tvp.The javaprogram is giviing thousand records per second to sql server using tvp.but sql server is inserting on 485 rows per second.But when i try to insert 40000 records in sql server using tvp(from sql server side) ,it is only taking 0 sec.So i thought it is due to

  N/w problem.but when the program run in the localhost also taking same time 3-4 sec per 1000 records.

  So it is not due to network.when we run in .net,it is working fine...is any problem with jdbc?any suitable driver for sqlserver2008.we are used JTDS and microsoft sql server jdbc driver.but the same result?what is the reason for this?

  *Note : tvp is only available for sql server 2008

  My server config is

  Intel(R) xeon(R) Cpu

  E5430@2.66GHz,2.67GHz

  Ram :4GB

  Any help is appreciated...

• Florian Reischl

  SSC-Dedicated

  Points: 37299

  More actions

  October 31, 2009 at 1:51 am

  #1073480

  Hi

  Could you post a snippet of your java code and your procedure?

  Thanks

  Flo

  ---

  The more I learn, the more I know what I do not know
  Blog: Things about Software Architecture, .NET development and T-SQL

  How to Post Data/Code to get the best Help How to Post Performance Problems