博客讨论了在数据库设计中将数值字段（如用户信用）存储为varchar类型的利弊。尽管varchar提供了更大的灵活性，但作者指出这会损害性能，因为varchar字段是变长的，无法预知数据大小，读取后需要转换为浮点类型，还可能导致精度问题和索引效率降低。建议尽可能使用特定的数据类型，如decimal，以提高性能和数据准确性。
I have to store user credits which can be in decimal format like (10.99, 0.99, etc.). For now i am taking the column field as varchar(100).
what if i use decimal instead of varchar. will it be improving the performance??
解决方案
The short answer is: No, it will hurt performance.
The longer answer: VARCHAR fields are variable length, meaning, that the formatting of the database blocks cannot pre-account for the size of the data filling in there. Sure, there's a maximum length of the field, but other than that, you're off worse.
On the other hand, reading a VARCHAR and then interpreting it to fit into a floating point type will cost you. And it introduces new problem possibilities. Try to get all decimals that account for "11.99". Hope you bring the right number of decimal places, because in VARCHAR "11.99" != "11.990".
And then there's indexing. Usually, nobody indexed a decimal field, but on the off chance that you do, an index on a VARCHAR field will require more space.
All in all, it's not a good idea to save something in an unspecific field type. In the DB structure, it's usually considered best practice to be as specific as possible.
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
