is it good design
Posted: Mon Sep 11, 2006 8:48 am
i am making classified system
i have main category as
vechiles,realstates,jobs,matrimonial,websites,education etc
i have table for each category which has about 17 to 18 columns
i want to separate service and seacrch extensively
it is to be intregrated in very famous site so it may grow up to millionsof records so
is my database design and concept good
or there are better way
can these all be done in one table but thing are diff for eg martomonial has fileds like hobbies ,reliogion where as merchandise has make,brand etc...
so cannot do all in one table
2 problem well as it is classfoed site the ad should be removed after some time
so for now i am thinking of putting one enum field which will be 1 or0 indicating either it is active ad or not
what will be better idea ...deleting it or keeping it
i fear those massive deletes every day will degrades performance
and what about putting that rows with 0 as enum filed as archive
any idea please help
another problem
i have for eg product short description filed which describes product
if i do tiny text,medium text it is not sufficent as i am planning to put some 10-20 lines so i am uisng texzt but i feel that is wasting lots of space what should i do
thanks for reply
i have main category as
vechiles,realstates,jobs,matrimonial,websites,education etc
i have table for each category which has about 17 to 18 columns
i want to separate service and seacrch extensively
it is to be intregrated in very famous site so it may grow up to millionsof records so
is my database design and concept good
or there are better way
can these all be done in one table but thing are diff for eg martomonial has fileds like hobbies ,reliogion where as merchandise has make,brand etc...
so cannot do all in one table
2 problem well as it is classfoed site the ad should be removed after some time
so for now i am thinking of putting one enum field which will be 1 or0 indicating either it is active ad or not
what will be better idea ...deleting it or keeping it
i fear those massive deletes every day will degrades performance
and what about putting that rows with 0 as enum filed as archive
any idea please help
another problem
i have for eg product short description filed which describes product
if i do tiny text,medium text it is not sufficent as i am planning to put some 10-20 lines so i am uisng texzt but i feel that is wasting lots of space what should i do
thanks for reply