Suppose i make field for image name varvhar 25 in database
then if user submit image its ok
but if user doesnt submits photo is that image field take any space or is that waste of space.
Does it effect in performance?
i mean does the blank filed effect in perfomance or consume space...
is it wasted of space
Moderator: General Moderators
- aaronhall
- DevNet Resident
- Posts: 1040
- Joined: Tue Aug 13, 2002 5:10 pm
- Location: Back in Phoenix, missing the microbrews
- Contact:
From the trusty manual: "VARCHAR values are stored using only as many characters as are needed, plus one byte to record the length (two bytes for columns that are declared with a length longer than 255)." Shouldn't represent much of a performance issue, but it would be better not to insert blank rows into the database if you can avoid it.