Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.6.10
-
Fix Version/s: 4.7
-
Component/s: None
-
Labels:
-
Documentation Required?:None
-
Funding Source:Contributed Code
Description
The setting to prevent an automatic wildcard should (importantly) prevent a wildcard being prepended to search strings. It is when wildcards are added to the start of a string that they have a big performance effect (at the end is minor).
Unfortunately this setting is being ignored for emails - leading to slow searches on large DBS
I also discovered that email has custom handling that appears to be intended to allow a search like "garfield@foodies.com" - ie with the quotes to be the string for an exact match. I don't think it works from my assessment - but it it is desirable it could potentially be used more widely as a pattern