HotcakesCommerce / hotcakes-commerce-core

The core of the e-commerce part of the overall solution. This is an ecommerce shopping cart solution built on top of the DNN (DotNetNuke) CMS. Anyone can do commerce online now!
https://mmmcommerce.com
MIT License
69 stars 55 forks source link

SI: Cache the Store Settings by ID and GUID #389

Closed mtrutledge closed 1 year ago

mtrutledge commented 2 years ago

Is your feature request related to a problem?

On almost every query that Hotcakes makes it needs to find the store id from the portal. Since this information is fairly static once a store is setup this is a good candidate to cache the data.

Describe the solution you'd like

When querying the store settings we should first check the cache. If the item is not in the cache, run the database query and add the results to the cache. Otherwise, return the value in the Cache.

Additional context

Querying the store settings is quick but there are many calls. This can reduce load on the database server.