Strings searches on MySQL databases are relative slower and CPU intensive
Opened this issue · 0 comments
sherlockwisdom commented
Refs:
- https://stackoverflow.com/questions/8844080/sql-performance-searching-for-long-strings
- https://stackoverflow.com/questions/8844080/sql-performance-searching-for-long-strings
- https://stackoverflow.com/questions/2346920/sql-select-speed-int-vs-varchar
Enhancements:
- Strings especially emails could be uniquely hashed and stored to reduce overhead