Unplanned
Last Updated: 29 May 2020 21:53 by Christopher
Victor
Created on: 06 Jan 2017 13:25
Category: UI for ASP.NET MVC
Type: Feature Request
19
Add cese sensitive filtering for the MVC Grid wrapper
The Grid should allow switching between case sensitive and case insensitive filtering.
5 comments
Christopher
Posted on: 29 May 2020 21:53
Please reconsider this item - to provide an opt-out for the case-insensitive lower expression so that indexes can be leveraged on SQL string fields.
OLSA Informatica
Posted on: 02 Nov 2019 08:25
I Agree, huge performance decrease on large SQL tables! Please fix asap
Paul
Posted on: 15 Feb 2019 08:52
I am agreeing with the rest of the comments, there is a lack of regard to the optimisation of the query being performed against the database, database developers and API developers go to great lengths to ensure case sensitive on models, databases and columns and then the Kendo library decides to lower everything causing our indexes to be worthless.
Holger
Posted on: 24 Mar 2018 03:00
This has a huge performance impact on large tables as the SQL ToLower prevents the database from using the index. 
Chris
Posted on: 09 Jan 2017 17:04
This really should be implemented. Adding the ToLower() calls to databases that are already case insensitive is a huge performance decrease.