How to handle high-volume inserts?
I'm relatively new to MSSQL, and I'm trying to improve the DB write performance.
I have some legacy Java code that's generating about 1500 records every second. These 1400 records are generated by multiple Java threads. Right now, my approach is to create an SQL statement in each thread, to write each record into the MSSQL DB; this is proving to be terribly slow.
What are my options specific to MSSQL and Java? How do I insert so many records into the DB without seriously impacting performance?
Thanks in advance.