filtering in the Web Client is causing a SQL query where the WHERE clause using a COLLATE LATIN1_100_CI_AI and a LIKE. This is a performance killer on tables with a lot of records because the SQL server is using then the clustered index instead of the proper index.
I can avoid that by using single quotes around the filter string.
I know NAV is doing it because of usability reasons. A user which is filtering for CustomerA wants to find CustomerA as well as customera. And it's fine for a small database like Cronus. But for big databases like ours it's a nightmare.
Is there a way to change that behavior. I would like to have a "as is" filter by default. In case the user want's something different he needs to adjust his filter with an @ or *. Like in the good old days