Site Planning Advice : Classified Ads data structure / method
Hey,
I'm looking for some advice, I'm currently in the stage of planning a build for a classified car ads website as a personal side project. I want to check whether my structure is correct or if there is a better way...
I've recently built a football league website using a similar structure and it seems to function well.
So far the basic node structure I have is:
Adverts
Advert 1
Content Picker (Make)
Content Picker (Model)
Content Picker (Year)
Content Picker (Colour)
Content Picker (Transmission)
Content Picker (Body Type)
Advert 2
Advert 3
Advert 1000+ (Hopefully)
Advert Options
Make
Make 1
Make 2
Make 3
Model
Model 1
Model 2
Model 3
Year
2014
2013
2012
2011
2010
Colour
Blue
Black
Red
Transmission
Manual
Auto
Body Type
Coupe
Saloon
Convertible
Touring
My main thinking behind this structure is that new options like "Model" can be added easily and possibly by the website user.
Later on I'd want to add in another node set with a location database which is around 2,900ish nodes broken down into Country, Region, Town.
I want to be able to list out the adverts by maybe by 4 or more of the options to give the user a really comprehensive drill down. Just apprehensive to whether this structure will slow down my querying.
Site Planning Advice : Classified Ads data structure / method
Hey,
I'm looking for some advice, I'm currently in the stage of planning a build for a classified car ads website as a personal side project. I want to check whether my structure is correct or if there is a better way...
I've recently built a football league website using a similar structure and it seems to function well.
So far the basic node structure I have is:
My main thinking behind this structure is that new options like "Model" can be added easily and possibly by the website user.
Later on I'd want to add in another node set with a location database which is around 2,900ish nodes broken down into Country, Region, Town.
I want to be able to list out the adverts by maybe by 4 or more of the options to give the user a really comprehensive drill down. Just apprehensive to whether this structure will slow down my querying.
Thanks,
Kyle
is working on a reply...