In Angular show records matching to search string from 50000 records

Thank you for your reply. I have a table (Item)that has 50k records.

User will enter item name in tectbox. e.g. 'co' 

So from 50k records, I have to show all items whose name start with 'co'.

 

What I am currently doing is, I am just firing a simple query  like

select ItemName from Item where ItemName like 'co%' 

I am sending this querie's result to front end And showing these all records using pagintion on front end.

If user changes search criteia/string from 'co' to 'cott'. Then again I am firing query and so on. But in this case I am fetching all matching records at once, which may be like overload

 

@Siddharth Gajbhiye Firstly, your articles are really very nice. nicely explained. In that, records are getting fetched  when we click on particular page. But in this case on every click there will be a roundtrip to database.This will also affect performance. If 100 users use this form/ item search page at the same time. 

Hello dip s

 

My point of view here is that you should go for server side pagination which will not decrease your application performance and you will show total records in pages but display only records in only for that page when you click on nexrt page it would again fetch again next records .

 

For this i have written some articles in server side pagination .

You can check this below.

 

 

https://www.c-sharpcorner.com/article/server-side-pagination-using-asp-net-core-and-angular-8/

 

 

Part 3 

https://www.c-sharpcorner.com/article/server-side-pagination-using-asp-net-core-and-angular-8-part-3/

 

Or you can go through the below link.

 

https://stackoverflow.com/questions/2807755/what-exactly-is-server-and-client-side-pagination#:~:text=Server%20side%20pagination%3A,links%20to%20more%20pages%2C%20etc.

 

 

https://dzone.com/articles/pagination-server-side-or-clie

 

 

Thanks