Quote:
Json file getting update everyone minute.
I have data in json file that contains 1 lacs real time record
And I guess you also expect the datagrid to reflect changes in json file on fly in real time.
Looks like every thing is wrong here.
The only sensible way to handle
1 lac record updated every minute is to use a database.
A datagrid is static, you have to load the data in datagrid, 1 lac record will take a lot of time and result will be difficult to use. To reflect real time update, you will have to reload data every minute.
This is like using a phone directory that you have to read sequentially without jumping to a page.
You have to make the form the same way as a book, you need the possibility to jump to a page number without browsing the book line by line.
a way to ease things is to use a virtual datagrid liked to database, such grid load only records needed for display. Coupled with a way to jump to a position, it can do the trick.