Anyone please help?
I am in a debate with the vendor about the following. In a web application, they convert all input into uppercase using
String toUpperCase. Their reasoning is it helps with quering the data in a search (
test vs Test). I suggest storing data as entered (filtering special characters, etc) and use SQL Server upper/lower function instead. Eg, for search criteria last=t*, query would be:
select * from user where upper(last) like upper('t%').
A small query analysis does show a performance decrease with using the function vs
select * from user where last like('T%'), given all data is CAPITALIZED
So, what is more memory expensive, given about 20 simultaneous users, calling toUpperCase when passing values into a database, or described above?