I wasted a lot of time with MySQL manual trying to understand this, and I'm starting to hate the 'manual' by now...
what INT types and sizes should I use in my MySQL tables to optimize the database?
SMALL TINY LARGE?
is it not to redundant to specify a INT type that expresses size and also a size/lenght variable? I miss something, obiously
per, ex. to store:
page_id (typically 1..15)
age (1.100)
image_id (more than 100)
nib (very big - how big can it be?)
now, i'm really lost:
what about CHAR and VARCHAR?
what type should I use and what size is optimal for
name (~50)
adress (~250, 255 is good?)
memo (~500)
biography (very big - how big can it be?)
Thanks A LOT
Andr?/div>Anon10-21-2000, 07:20 AM
what INT types and sizes should I use in my MySQL tables to optimize the database?
SMALL TINY LARGE?
is it not to redundant to specify a INT type that expresses size and also a size/lenght variable? I miss something, obiously
per, ex. to store:
page_id (typically 1..15)
age (1.100)
image_id (more than 100)
nib (very big - how big can it be?)
now, i'm really lost:
what about CHAR and VARCHAR?
what type should I use and what size is optimal for
name (~50)
adress (~250, 255 is good?)
memo (~500)
biography (very big - how big can it be?)
Thanks A LOT
Andr?/div>Anon10-21-2000, 07:20 AM