Pending Review
Last Updated: 10 Sep 2018 16:06 by Vasim
Holger
Created on: 24 Aug 2018 15:05
Category: Kendo UI for jQuery
Type: Feature Request
4
ToDataSourceResult avoid casting to lower() to enable index use in database
When using a grid against a large table with server side filtering (ToDataSourceResult)

ToDataSourceResult builds a SQL query that converts the search string to UPPER() and therefore prevents the database from using its indexes. As SQL comparison is case insensitive that LOWER() is unnecessary.  

As we have may grids where this is an issue it would be time consuming to build out manual filters for each grid instead of using ToDataSourceResult

This was discussed here and there was no solution at the time:

https://www.telerik.com/forums/grid-filtering-on-text-using-lower-in-sql

I would liek to request an option to tell ToDataSourceResult() not to use LOWER() in the sql?

See ticket #1339310
1 comment
Vasim
Posted on: 10 Sep 2018 16:06
+1