Woocommerce backend timing out - slow queries

$30-250 AUD

Igangværende

Slået op

cirka 3 år siden

$30-250 AUD

Betales ved levering

I'm getting slow db queries which are causing issues... let me know if you know how to fix Examples: 1. Executed 23h 38m 48s ago for 2.449173 sec on Database --> ####### Date: 2021-04-11 08:46:59 Query_time: 2.449173 Rows_examined: 1121416: Rows_sent 1121416 Lock_time: 0.000042 Query_chars: 79 SELECT /*!40001 SQL_NO_CACHE */ * FROM `sales_bestsellers_aggregated_monthly`; ------------------------------------------------------------------------------------------------------------------- 2. Executed 23h 38m 28s ago for 2.243186 sec on Database --> ########### Date: 2021-04-11 08:47:19 Query_time: 2.243186 Rows_examined: 1259039: Rows_sent 1259039 Lock_time: 0.000036 Query_chars: 54 SELECT /*!40001 SQL_NO_CACHE */ * FROM `wp_postmeta`; ------------------------------------------------------------------------------------------------------------------- 3. Executed 23h 38m 8s ago for 2.239818 sec on Database --> ############ Date: 2021-04-11 08:47:39 Query_time: 2.239818 Rows_examined: 1256080: Rows_sent 1256080 Lock_time: 0.000045 Query_chars: 54 SELECT /*!40001 SQL_NO_CACHE */ * FROM `wp_postmeta`; ------------------------------------------------------------------------------------------------------------------- 4. Executed 21h 32m 48s ago for 2.069343 sec on Database --> ############ Date: 2021-04-11 10:52:59 Query_time: 2.069343 Rows_examined: 558240: Rows_sent 288 Lock_time: 0.000192 Query_chars: 650 SELECT wcoimeta.meta_value as product_id, SUM(wcoimeta2.meta_value) as product_total FROM wp_woocommerce_order_items AS wcoitems INNER JOIN wp_posts AS wcorders ON wcoitems.order_id = [login to view URL] AND wcorders.post_type = 'shop_order' AND [login to view URL] ...... INNER JOIN wp_woocommerce_order_itemmeta AS wcoimeta2 ON wcoimeta2.order_item_id = wcoitems.order_item_id WHERE ( wcoimeta.meta_key = '_product_id' OR wcoimeta.meta_key = '_variation_id' ) AND wcoimeta2.meta_key = '_line_total' GROUP BY product_id; ----------------------------------------------------------------------------

Projekt-ID: 29859092

Om projektet

9 forslag

Projekt på afstand

Aktiv 3 år siden

Leder du efter muligheder for at tjene penge?

Emailadresse

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme

Bliv betalt for dit arbejde

Oprids dit forslag

Det er gratis at skrive sig op og byde på jobs

Tildel til:

@grameenmelanet

Hello, I read your requirements and understand very-well and ready to start-up right away. I am sure you are looking for an experienced and expert person to work in your project. I am in this sector since 2011. Please if you have time, take a look of my freelancer profile. For more discussion, please open chat. Thank you

$50 AUD på 1 dag

4,8

(321 anmeldelser)

7,2

9 freelancere byder i gennemsnit $157 AUD på dette job

@yalinvyacheslav

Hi, I have read your description word by word, and finally made decision to help you. If you are looking for someone who can build your website perfectly, I’d love to be considered. I am a web Developer and Designer since 2010. I have good experience in building large scale web applications using PHP. - Front-end Skills HTML 5, CSS 3, Bootstrap, JQuery, Vue JS - Back-end Skills PHP, Laravel, API, Python If you award me the project I'd be very happy to discuss this further and get started for you as soon as possible. Thanks!

$100 AUD på 7 dage

5,0

(4 anmeldelser)

4,1

@moizdzo3l

Greetings, I am qualified with all the above mentioned requirements. I can surely assist you in fixing issues for a website for your business. I have worked on various development platforms and I can also assist you in writing SEO content as well. I can deliver the project on tight deadlines and revise the work accordingly as per your comments. I am fully aware of building websites by using HTML5/CSS3, .NET, PHP, etc and it's one of my expertise. I have recently worked for for different websites like, video surveillance, march networks, axis, Mzad Qatar, Dubbizle, OLX, etc. As these are my permanent clients and Iam dealing with them on monthly basis. Having experience of 7+ years in the IT industry, I can assist you with your website. I have worked on multiple web designs, web templates, coding, decoding, PHP, .NET, CSS, etc. in my career. My content can get the attention of your desired target audience which will assist in expanding your online presence. I believe that you are looking for a web designer, and I can assure you 100% succession, with delivery within the deadline. For long-term collaboration package deal can also be done as per your requirement. Hopefully, my quality of work will let you hire me on monthly basis. Kindly come on chat so that we can discuss your project details further. Thanks.

$250 AUD på 7 dage

5,0

(2 anmeldelser)

4,1

@TarekWS

Hello I hope you are fine. I have much experience in that field, so l can update the way your query runs. I have read the description and already have pictures of how it will be. Thanks, Tharek

$100 AUD på 5 dage