By sid316 on

I am planning on starting an online bookstore, which will have around 15 million books. I'm not expecting a significant number of page views per month, so traffic will be fairly low. There's only a single product type (book), with a few informational fields such as Author, Publisher and a single cover image. There are no product variations. Payment is cash on delivery or bank cheque for now, with support for credit card payments to be added later. I need some advice regarding how to implement this.

Is Commerce Kickstart a good solution for this many products ? What database would I use (if MySQL would slow things down) and how much customization and optimization (for databases, server, etc) would I need to do to ensure performance is good ? Is Drupal 7 sufficient for this project or should I wait for Drupal 8 (if it provides any advantages) ?

Also, what kind of hosting environment would be suitable for this ? I've heard a lot of good things about Pantheon. Any suggestions would be very helpful. My primary concern is making sure the site doesn't get slowed down by that many products. Thanks.

⋅ Categories: Drupal 7.x

Comments

Jaypan’s picture

Jaypan commented

Your site will be extremely slow with 15million products. You would definitely want to spin out caching of your data into other databases. Two options are:
1) Cache your product objects in Redis
2) Cache your product objects in Apache Solr

Both will require custom coding and overriding of default behaviors.

I've done both on my own systems, but not with Drupal commerce, so I can't really give you directions on how you would go about it.