Hello,
In my ASP. NET MVC project I used many GridView Extensions.
To display a grid, an action in a controller first retrieves the data from a database, then builds a view model from this data and finally calls the display of the grid with the view model.
For now I don't use pagination, so all data (that means the data of all pages of the grid) are retrieved from the database and sent to the grids.
Once a grid is displayed, all action done into it (filtering, navigating though grid's pages…) send a callback to the server. In this callback we need to retrieve again all the data from the database, then we have to create the view models and finally we have to call the display of the grid.
As the retrieval of the data from the database can take time, I decided to store them in user server's session at grid's creation and to retrieve them from the session in the callback. This way it is much more faster!
This works fine, but as the number of users of my website is increasing a lot, I will shortly have to use a load balancer.
But load balancing and server's sessions are incompatible.
I there a way to use callbacks (or even not to use them) without session and without having to request each time the database?
Best Regards