Querying data Linq asp.net mvc

Hi guys,

I am querying a Sql database with LINQ and I listed to show it in view. The problem is the data which come from sql is pretty big like around 100000 rows and when it sends to the view it is very slow.
How can I query this data in a quick way and show the list to the view

Here is my example:
Linq:

var translist = (from b in rmdb.Batches
                             join c in rmdb.Registers on b.RegisterID equals c.ID
                             select new Searchmodel
                             {
                                 Batch = b.BatchNumber,
                                 Registernum = c.Number,
                                 Registername = c.Description,
                                 OpenTime = b.OpeningTime,
                                 CloseTime = b.ClosingTime,
                             }).OrderBy(a => a.Batch).ToList();

Select allOpen in new window

The purpose I'm doing it is to let users search true the list and get the transaction they are looking for.

Here is my view example:




I have 2 tables POINTS (with around 100 000 rows) ,