Grid Filter Row Problem

[Peng]

Hi there I am trying to do http://demos.telerik.com/aspnet-mvc/grid/filter-row for my application. But there are some functionality I want to control but fails to do so and I can't find it anywhere on the documentation. 

Since I have a lot more data than the demo here (15,000 people), loading all the auto complete from the filter the moment one character is typed in will result in a very slow and bad user experience, and often times it will pop up a window like the screenshot telling me "Error during serialization or deserialization using the JSON JavaScriptSerializer. The length of the string exceeds the value set on the maxJsonLength property."

How can I control when the auto complete shows up? 

I did something like this in order to start auto complete after three characters, is this right? Any better way to control the whole project instead of just one column?

        columns.Bound(i => i.LastName)
            .Filterable(ftb =>
                ftb.Cell(cell => cell.MinLength(3)
                ));

 And when I clear the filter, it will load up a list with all the people here, which is not something I want and it will often stuck there for 10 seconds and then shows the error. How can I disable it?

 

[Peng]

Btw, I am using official 2016 Q2 Release (2016.2.504) and Visual Studio 2013, on Windows 10 64 bit.

[Milena]

Hello,

The error you are facing is related to the default maxvalue defined by the ASP.NET MVC framework. Please navigate to this help article, where you will find possible workarounds for this limitation.

Regards,
Milena
Telerik