title: Sybase ASE 15.5 : Slow insert with JDBC executebatch()
body: <p>I'm using Sybase ASE 15.5 and JDBC driver jconnect 4 and I'm experiencing slow insert with executebatch() with a batch size of +/-40 rows on a large table of 400 million rows with columns (integer, varchar(128),varchar(255)), primary key and clustered index on columns (1,2) and nonclustered index on columns (2,1). Each batch of +/-40 rows takes +/-200ms. Is the slowness related to the size of the table? I know that dropping the indexes can improve performance but unfortunately that is not an option. How can I improve the speed of insertion?</p>
  
  <p>NOTE : This is part of the application live run, this is not a one shot migration, so I won't be using bcp tool. </p>
  
  <p>EDIT : I have checked this answer for mysql but not sure it applies to Sybase ASE <a href="https://stackoverflow.com/a/13504946/8315843">https://stackoverflow.com/a/13504946/8315843</a></p>