i have to implement a api in net core that accept items (with 5 simple fields), check if they exists on a SQL server database and insert/update them. Every user will call this api 2-3 times a day and needs to pass about 500 items.
What is best approch in terms of performance (ti not overload my system): A) Accept a compressed JSON, make 500 read and write sequentually and return status B) Accept a single item and tell the user to call it for each item (so about 500 x 3 times a day) C) Accept a compressed JSON, return an operation id, do operations in an asyncronous task and return result in a different api through the operation id.
Thanks
Top comments (0)