I planning to improve a Drupal 7 commerce store, containing 4.5 mill distinctive merchandise, on this set up it is a single product kind with round 30 fields and about 5 taxonomies.
Day by day theres about 100.000 product updates from an exterior useful resource, and with our large server with 100 gb ram and really quick disks, it is a heavy job as a result of it takes a whole lot of time to save lots of these entities to db.
Subsequently i’ve thought then constructing it up from scratch, I’ll go along with a single product kind, and a customized entity (ProductData) containing all 30 subject in a single document, referenced by an ID to Drupal Developer Product. In that case Drupal Developer updates can be loads sooner + Drupal Developer database will likely be loads smaller
And one other thought; Is it potential to make Drupal Developer ProductData entity saved in SOLR / ElasticSearch and never in Drupal to hurry up Drupal Developer processing ?
Let me hear your ideas ?