Magento1.9 performance fixing

Hi! I am highly experienced in MySQL and databases in general, so for me it is easy to fix errors happening in SQL code. Tell me more about your query error and I'll fix it ASAP

Questions: - What query consumes too much CPU resources? - Can you grant SSH access to your server? Recent Magento 2 Tasks: - Performance improvement with Apache web server configuration w/o .htaccess overrides - Performance improvement with Redis installation and configuration for backend and session storage - Module for pushing Google tag purchase event information on order success page - Module for pushing selected orders to a delivery management application - Module for restricting checkout for quotes matching configurable attribute details - Theme for customized product details, category and product slider templates - Module for submitting orders received from custom call-center script - Performance improvement with Varnish installation and configuration for Magento 2.3.5-p1 - Version Update from Magento 2.3.3-p1 to 2.3.5-p1 - Show out-of-stock products in full text search (w/o showing out-of-stock products in general) - Only show one product for full text searches with exact SKU matching (case ignored) - Automatic SMS for MyFatoorah_MyFatoorahPaymentGateway (Magenest_Pin) - User customizable text for checkout message - A custom shipping method matching user defined rules - Order history comment modification by adding the authenticated backend user name to the order history comment - Shopping cart quantity restriction for selected product SKUs for desktop site and mobile application

Hi There, I've reviewed your requirements.I have 4 years experince software development and query optimization. i will optimize the query asap Please leave a message,so we can discuss the project in more detail as well negotiate a competitive budget. Thanks.

Hi I have rich experience in Magento i have developed so many project before I can do it perfectly Thanks