Page 1 of 1

is it wasted of space

Posted: Thu Sep 14, 2006 11:35 pm
by rami
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...

Posted: Fri Sep 15, 2006 3:14 am
by Weirdan
it certainly consumes space, but not that much space to bother IMHO.

Posted: Fri Sep 15, 2006 3:57 am
by aaronhall
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.

Posted: Fri Sep 15, 2006 5:19 am
by rami
well i cannot means some people will have image but other wont have
or they dont want but i should give them option...
but i dont know how many will upload image so i was bother about either keeping it or not
thanks for answers