Regarding fetching huge data.

Mandar Shinde

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo6y ago
Accepted answer
hi

bring limited data is better way .Because to retrieve and loading the data take less time instead of huge one.

do not worried for 100 users .Becase database is the server and the users are the clients.

Thanks and regards
+3
Prasad Rane6y ago
It makes sense to load limited data.making 100 calls to database is not a problem here.
+2
Salman Beg6y ago
Hey use paging concept and retrieve bunch of records in place of whole 50000. If you retrieve 50000 records by multiple users then performance will be very slow. If you retrieve only few records by multiple users then it will not impact more. Thanks.
+2
Navaneeth Krishnan6y ago
1. Use asynchronous calling
2. Load data on Demand
+2