1
0
-1

the TextFieldDataListFilter creates a where clause ' where lower(" + cname + ") like lower(?)'

This where clause is slow on the SQL server with large tables because the DB index cannot be used with lower().

Is there a way to have the where clause without 'lower()' ? The SQL server uses by default case insensitive search so the lower() makes no difference in the search result, it is just slower.

Of cause I could write my own plugin, but here an option on the TextFieldDataListFilter to not use lower() may help also other customers.

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi, I believe the current implementation of the plugin is to cater for different database behaviors but yes, there should be an option to disable it. Until that is added I think you would need to extend it with your own implementation though.

        CommentAdd your comment...