asp.net mvc application using HeidiSql

Question

i am using asp.net mvc using repositary and database is mysql with store proceure when i am develop application using this my application is very slow because i want to display thousand of record at page load time so what is the better way in asp.net MVC Application

Nilesh Makwana · Answer

1. Are you using Jquery DataTable? -- Ans - yes 2. How you are getting records from DB ? Using EntityContext or StoredProcedure? Ans - using store procedureand create repositary class for call sp 3. How many records you want to show at page load time every time? Ans 10 Record using pagination

Rupesh Kahane · Answer

Their are many ways like 1) You can use lazy loading mvc. 2) You can use in built mvc pagination available. Refer http://www.c-sharpcorner.com/article/paging-and-sorting-in-Asp-Net-mvc/ or http://www.c-sharpcorner.com/UploadFile/4b0136/perform-paging-searching-sorting-in-Asp-Net-mvc-5/ 3) Also by linq it is possible & repository is also good. 4) Use dapper in mvc so you will get better performance. 5) You can use javascript pagination. Le me know if you need any help

Ramesh Palanivel · Answer

Hi Nilesh, Please provice some valuable comments for below questions. 1. Are you using Jquery DataTable? 2. How you are getting records from DB ? Using EntityContext or StoredProcedure? 3. How many records you want to show at page load time every time?

Brian Ray · Answer

Hi, In this case I would recommend to check ZetPDF.com library .

asp.net mvc application using HeidiSql

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)