0

I want to write a web api which should receive Excel / csv files with around 10 columns and parse and insert into a normalized SQL Server database using SqlBulkCopy (4 foreign key constraints, 2 non-clustered indexes).

What will be approximate achievable TPS (transaction per second) within default timeouts and with 8GB memory?

The upload operation will happen once in a while with approx 1 million records.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Imran Rizvi
  • 7,331
  • 11
  • 57
  • 101

1 Answers1

0

I have tried this scenario and able to achieve 6000 TPS without timeouts and memory overload.

Imran Rizvi
  • 7,331
  • 11
  • 57
  • 101