Answer the question
In order to leave comments, you need to log in
Reading data from MS Access to ASP.NET. What's better?
There is a system for displaying temperature data to the user with the ability to filter by date (from - to) and select a sensor. Each time the data is redrawn on the graph (Zedgraph).
When working with MS Access and ASP.NET, which option is better to use - read all the data in the DataTable and store it in memory, and when changing sensors, pull data from memory. Or, with each change, read data only for the requested sensors from the database?
The data is not displayed all the time - there are other tabs.
Answer the question
In order to leave comments, you need to log in
MS Access is, in general, not a very good option, starting from licensing.
Better then SQL Express as storage and Asp.Net MVC on IIS as a frontend.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question