Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Kyle 24 posts 63 karma points
    Sep 26, 2014 @ 23:19
    Kyle
    0

    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.

    Thanks,

    Kyle

Please Sign in or register to post replies

Write your reply to:

Draft