Slowing down site when data is called

Hi, I am building a website that sells Auto spare Parts…

I purchased a theme that has Woocommerce to facilitate the shop. I host the site with Ionos (Share Hosting)

So when I installed the theme it was working just fine, however, as soon we uploaded the vehicle data the site was very very slow..! So I I tried so many things with my knowledge such as installing a few optimization/cache plugins. etc.

Because I was told as I am having a large amount of Data (70,000) of vehicle information And each vehicle could have hundreds of spare parts..! I need to optimize using those plugins.

Apart from that, I would have reinstalled the WordPress minimum of 3 times. Likewise, I am wrestling with this for over a year..!

please check this link https://www.screencast.com/t/yZVRy1SdEF

I really do not know where to go from here, I contacted theme support and they say there is nothing wrong with the theme..! I want to know whether WordPress and WooCommerce could handle this type of website..! If so What will I have to do.? Could someone, Please help and guide me to find an end to it..? Truly appreciated

• This topic was modified 2 years, 5 months ago by t-p. Reason: Moved to Fixing WordPress from Everything else WordPress

The page I need help with: [log in to see the link]