1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Building database for marketplace - where to start?

Discussion in 'Databases' started by oddink, Nov 29, 2016.

  1. #1
    Where to start to build a good, useful database for a website that is similar to this one: https://zoptamo.com/uk/s-crossfit-c-uk ? Also, database optimisation tips are appreciated too (base should be fast and records should be easy to find).
    SEMrush
     
    oddink, Nov 29, 2016 IP
    SEMrush
  2. PoPSiCLe

    PoPSiCLe Illustrious Member

    Messages:
    4,626
    Likes Received:
    719
    Best Answers:
    151
    Trophy Points:
    420
    #2
    Create a plan for the database. All the tables, all the relations among the tables, and so on. Then you will see where you need to have indexes, where foreign keys should be used, where you can get away with using internal triggers, and so on. Also, stored procedures will aleviate some of the pressure on the database, depending on type of usage. If this is a product-database, you will mostly just pull content from the database, and maybe change stock-amounts. The rest will be mostly storing of orders and such, again not very demanding.
     
    PoPSiCLe, Nov 29, 2016 IP
  3. oddink

    oddink Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #3
    Oh, huuuge thanks for replying and this number of useful advices :D Also sorry for late reply here ;)
     
    oddink, Dec 8, 2016 IP