1: Heavy website SQL 2: Product attributes

Closed
REHub - Price Comparison, Affiliate Marketing, Multi Vendor Store, Community Theme REHub - Price Comparison, Affiliate Marketing, Multi Vendor Store, Community Theme November 23, 2020
Login to reply
Igor Sunz Support Agent
3 years ago

I don't know because you didn't provide me any details

Yoreh Schipper
3 years ago

Yeah I know and most of the options I turned off because I need them, But still there are a lot of SQL processes. Do you have an idea which things I could change to lower those processes? What should I check or do different to make everything faster and lighter? 

Igor Sunz Support Agent
3 years ago

for attributes, you need to delete them one by one only. Also, products
don't have any attribute when you create it. Check settings of your
plugins, especially if you use bulk imports

Igor Sunz Support Agent
3 years ago

1. theme is not heavy for server as we use conditional logic in theme and
nothing is loaded until you enable it. You can disable all options which
you need in theme options

Yoreh Schipper
3 years ago

Hi,

Question 1: Last saturday evening my website (https://cameradeals.be) went offline because it couldn't reach the database. It has been offline till monday morning until I managed to put a database back-up restore on the website. According to my hosting company they say that it went offline because of too many SQL processes (30) and if they get too much it will go offline, due to a heavy website. I know the theme itself and Woocommerce are heavy for the server. Is there something I could do to minimalize the (SQL) processes and requests or make the website lighter? -> I already read the whole document you provided to optimize the site-speed and I use small images, cache etc.

Question 2:

When I load in new products it comes with Product Attributes and sometimes I forget to delete them before saving the page. When I go to Products > Product attributes, I s a list of all the product attributes. I know having to many slows the website down, but I can only delete them one-by-one. Is there a way to bulk delete attributes? I put a screenshot as a attachment. 

Thank you!