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