What you are doing is not at all recommended. When the number of users will increase, your website may start giving
OutOfMemory
exceptions and many users will experience time-outs.
Use
GridView paging[
^] to display only certain number of records on a page. The user can page through the records. You may also extend the features and add search facility for the records.
Again, there are certain performance considerations when you are getting so many records from database and using paging. You have two important things to consider:
a) memory usage on the server - DataTables will take a lot of memory if huge records are fetched at a time.
b) database hits - more the no. of hits, more time it takes to process the page.
You will have to optimize your web page to use best combination of both the techniques display so many records.
You may also search Google/Bing for displaying large records in Gridview and performance considerations.
Hope this gives you a start. ! :thumbsup: