I am using MVC, EF & Repository, and database in Azure. I have a table, that has only 5 columns. ID, name, message, Exceptions & otherdetails. Exceptions & otherdetails, both are a varchar(max) datatype. Now, Exceptions column max string length is a 2300 word & otherdetails column max string length is 1500 word.
 can anyone tell me, the faster way to find whole data? because now I am searching one-day data, so it took almost 20sec or more to execute. I executed the same query in SQL. but it took the same time. Also, I tried to use table view but the same time to execute.
here is my code - 

```
public IEnumerable<ErrorLogModel> GetErrorLogData(DateTime? startDate, DateTime? endDate)
    {
        return _unitOfWork.ErrorLogRepository.Get(e.Date >= startDate && e.Date <= endDate).Select(e => new ErrorLogModel
        {
            ID= e.ID,
            name = e.name,
            message= e.message,
            Exceptions = e.Exceptions,
            otherdetails = e.otherdetails
        });

    }

```