Have a running database using Magento version 18.104.22.168. Since the installation of the site, the database performance has been > 10-18 seconds to get a product loaded to the cart or to change the quantity of the item purchased. Would like response time to be less than 3 seconds (if that's possible with Magento).
Number of items in the cart is about 1000.
The original database was implemented in OS Commerce and migrated into this Magento version. Customer likes the front end but unhappy about the database performance as we are.
So, seeking skills to analyze, determine cause, and provide fix to SQL or other parameters that might impact this database's performance.