Best way to create a search / database driven site

Discussion in 'HTML & Website Design' started by RedGBarn, May 9, 2011.

  1. #1
    I want to build a new website and would appreciate some guidance on whether I can use a package to achieve this or if it needs to be built from scratch

    The primary function will be to hold a database of pictures and/or links
    I want to hold these in a database so that I can apply attributes to each

    Eg:
    Link 1 – tagged as red / big / round
    Link 2 – tagged as blue / small / round

    I then want to apply a search box on the front page where the user can select the attributes
    So that
    Red / big / round – would return a list of matches – in this case link 1
    Just selecting round would return link 1 & 2

    Thanks
     
    RedGBarn, May 9, 2011 IP
  2. ntomsheck

    ntomsheck Peon

    Messages:
    87
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Depends on how big your DB is. If it's going to be relatively small, just a regular LAMP stack will work. Use MyISIAM tables with a FULLTEXT index. If it's going to be huge (millions of links), use a search indexer like solr or sphinx. Frankly, I'm in love with solr. It's the base of one of my sites, and it can blow through 20M entries in 0.03 seconds on average. Steep steep learning curve though.
     
    ntomsheck, May 9, 2011 IP