I am working with a team that is trying to implement an EAV system. They have decided to split the attribute-value tables out by type and they are debating using different tables for different size ranges of varchar.
- table_1 - up to varchar(10)
- table_2 - varchar(11) TO varchar(500)
- table_3 - varchar(501) TO varchar(MAX)
I have always been under the impression that varchar was only going to use the size that it needed.
Do you know if this is going to have any gains in performance and would it be worth the extra coding / logic that would be needed?