Regarding fetching huge data.

Question

Dear all,

I hope everyone is well. I am buildin one application using ASP .net web api and Angular 9.

I am building application as inventory management. There are near about 50,000 items in my database.

I want to develope autocomplete for fetching data.

Is is good idea to bring all data using query or I need to bring limited data.

I am worried beause if 100 of users try to get items like this way then it will be huge burdon on database.

Please suggest me solution on above problem.

Thanking you in advance.