Filter Toolbar without loadonce:true?

Question

I am using jqgrid, with filter toolbar(column) option...The total data is around 10,000...So it seems to be some delay in initial loading as the config is set to loadonce:true;

Any way to implement the filter column feature with loadonce:false ? Because the data loading delay is okay with loadonce:false. If I get a chance to add column filter with loadonce:false, this will work perfectly...

Answer 1

If you has about 10,000 rows it is of course better to implement server side data paging, sorting and filtering. I recommend you to use filterToolbar with the parameter stringResult:true if you not already use it. In the case jqGrid will send to the server filters parameter in the same format like advanced searching as do. So you will need implement on the server side the method which use following input parameter from jqGrid:

• sidx and sord parameters define the sort order of the data. The informations specify ORDER BY in the corresponding SELECT statement.
• if _search parameter is true, then the next parameter filters gives additional information which construct the WHERE part of the corresponding SELECT statement.
• page and rows parameters define which page of the data previously sorted and filtered should be returned.

The exact implementation is depend on the language and technology which you use on the server and of course which database server and which interface to the database you use.