asp.net mvc application using HeidiSql

Nilesh Makwana

8y1.6k.NET

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Brian Ray8y ago
Hi,
In this case I would recommend to check ZetPDF.com library.
0
Nilesh Makwana8y ago
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
+2
Ramesh Palanivel8y ago
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?
+1
Rupesh Kahane8y ago
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
+2