I'm creating my own shopping cart component and I can't choose what way of storing products and categories would be the best. There are the following few options:
1. A fully independent component with its own table for products and separate table for categories (as Virtuemart does)
2. A component with its own table for products but with binding them to Joomla Categories
3. A component using Joomla Categories and Joomla Articles as products (as J2Store does, see the link about benefits)
4. A fully independent component with one common table for products and categories and another table for relations between them (as I described by the link)
Perhaps there is some else way. What way would be the best from the standpoints of simplicity in developing and integrating, speed of working especially if there will be thousands of products etc. Please explain.
Thanks in advance