Skip to Content
avatar image
Former Member

Sybase ASE 15.5 : Slow insert with JDBC executebatch()

Hello,

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers