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 :)
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.
Umbraco Content/Documents vs Entity Framework
Guys, when you need to create a database of say "Products" and "Product Categories", or anything, would you:
An advantage of this is having foreign key relationships
The advantage is of course you can manage it in Umbraco straight away without creating a custom section
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.
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
is working on a reply...