So I am trying to build a blazor web app and I added model classes for separate database tables that already exist on a sperate server, I then put a sql query using dapper that takes all that data from the model classes and puts it together into a Telerik grid, and I need help making my query run a bit faster (The SQL query takes 28 seconds on SSMS I am trying to add paging where it doesn’t have to execute the whole query before it starts loading the grid). I also am having issues with auto fitting that into the grid and I have no idea how to get it to work. And P.S. , I am a beginner at all this.