If the data volume is huge, which approach is better? Our source data is stored in excel. So using the excel as data source or loading the data to a database like SQL server and using that as data source?
what about 1 million rows from excel source? Will that be an issue from the "app data reload" point of view? And what about storing the excel? I am thinking it has to be placed in a server folder or in a shared folder which can be accessed by both server and developer machines. Will that be a problem?
Currently I am not working with any huge files. This is for a future app proposed by client. They say they have data in excel files and the data size is huge. So I just want to be sure so that we don't run into problems later, both development and maintenance point of views.