在Asp.NET MVC中过滤大量记录的最好方法是什么？

// 控制器中的代码
public ActionResult Index(int? page, string filter)
{
    int pageSize = 10;
    int pageNumber = (page ?? 1);

    // 根据筛选条件构建查询语句
    var query = db.Records.AsQueryable();
    if (!string.IsNullOrEmpty(filter))
    {
        query = query.Where(r => r.Name.Contains(filter));
    }

    // 分页显示数据
    var records = query.OrderBy(r => r.Name).ToPagedList(pageNumber, pageSize);

    return View(records);
}

// 视图中的代码
@model PagedList.IPagedList<Record>
@using PagedList.Mvc

@using (Html.BeginForm("Index", "Home", FormMethod.Get))
{
    <p>
        Filter: @Html.TextBox("filter")
        <input type="submit" value="Filter" />
    </p>
}

<table>
    <tr>
        <th>Name</th>
        <th>Age</th>
    </tr>
    @foreach (var record in Model)
    {
        <tr>
            <td>@record.Name</td>
            <td>@record.Age</td>
        </tr>
    }
</table>

@Html.PagedListPager(Model, page => Url.Action("Index", new { page, filter }))