Is there anway to perform backend query for Multi-Select control
We're trying to implement Multi-Select control for a list with aboult 20000 records.
We found it's very slow.
After checking the tracer and network trace, we found it seems the data filter was performed at the frontend.
For our case, when enter keywords to search:
1) The back end responsed all 20000 records.
2) The front end perform the filter with entered keywords.
We're wondering if there anyway the data filter could be done at the backend?
For example, the keywords could be sent to backend, and use SQL query to filter out records with this keywords.
The performance should be much more better than the front end filter.
Appreciate a lot if anyone can help.
Thanks.