Extraneous LOWER() calls in Membership provider

Extraneous LOWER() calls in Membership provider

Postby njb » Thu 28 Sep 2017 15:43

We are discovering that there are apparently extraneous calls to LOWER() in the Membership Provider's select statements. These slow the queries down tremendously and are completely unnecessary when the MySQL database is set to case insensitivity. Is there any way to remove the LOWER() calls via a config file?

We are running the very latest dotConnect for MySQL.

I need to point out that this is mission critical for us. Our Membership table has hundreds of thousands of rows and the LOWER() calls force a _full table scan_ of the membership table. This obviously slows things down tremendously. We have captured the SELECT calls and removing the LOWER() calls from the SELECT speeds things up by an order of magnitude. I cannot find a way to open a trouble ticket, so I guess this is the only way to do so

Posts: 4
Joined: Sat 25 Feb 2017 01:12

Re: Extraneous LOWER() calls in Membership provider

Postby Pinturiccio » Tue 03 Oct 2017 11:56

Yes, you are right. We are using the LOWER function in select queries. We will investigate the possibility to remove this function from our queries in the Membership provider and post here about the results.
Devart Team
Posts: 2046
Joined: Wed 02 Nov 2011 09:44

Return to dotConnect for MySQL