title: JQuery datatables search by date in the table
body: <p>I'm using JQuery datatables. In the first load of the page that has two datatables in it, there are almost 7000 rows to load and it takes so much time. What I'm trying to achieve is, placing two datepickers to load between specific dates so that it doesn't take so much time to load the page at first. However, I have a question in my mind: to use datatable's datepicker for filtering, do I still need to load the whole data at first page load? Or, when I change the dates, it will go to repository to start the LINQ that queries for the specific date? </p>