Copied to clipboard

Flag this post as spam?

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


  • Aximili 177 posts 278 karma points
    Mar 30, 2015 @ 02:23
    Aximili
    0

    Umbraco Content/Documents vs Entity Framework

    Guys, when you need to create a database of say "Products" and "Product Categories", or anything, would you:

    • Create a new table in database?
      An advantage of this is having foreign key relationships
    • Create a new Document Type in Umbraco to put all data in Content
      The advantage is of course you can manage it in Umbraco straight away without creating a custom section
    And which is faster to lookup?
    Say if you need to quickly get Product(s) by SKU or category.
    In database tables, you just need to index the column(s) and it'll be fast. I'm not sure about Umbraco speed.

    Any other input/considerations I could be missing? Thanks in advance :)

     

  • Jeroen Breuer 4908 posts 12265 karma points MVP 4x admin c-trib
    Mar 30, 2015 @ 12:13
    Jeroen Breuer
    1

    Hello,

    Using the second option is probably faster to develop because a custom section can be a lot of work. Umbraco has some good caching so performance should also be good.

    You could also have a look at uWebshop or Merchello which already do the product management for you.

    Jeroen

Please Sign in or register to post replies

Write your reply to:

Draft