Dave has been programming since 6 years old and has been developing Wordpress plugins, themes and websites since 2010. In the past he built the browse view technology for Skyscanner and now he helps clients with interesting website challenges. He is always on at least one of his computers when he's awake, so get in touch and he'll get right back to you.

10 Comments

  1. Eric
    November 21, 2014 @ 7:01 pm

    Nice post, Dave! Very helpful. I will be pointing many folks to this article. If you write any more tips and tricks regarding optimizing WordPress and WooCommerce, let me know so I can send our members to those articles, too. 🙂

    Eric

    Reply

  2. Eric
    November 21, 2014 @ 7:08 pm

    One last thing to add regarding W3 Total Cache, do not enable Object Cache. That bypasses the WordPress Transients API which the Datafeedr plugins rely on for storing data to reduce the number of API requests required to build and update your products.

    Reply

    • Dave Hilditch
      November 22, 2014 @ 6:53 pm

      Thanks for that Eric. I’ve found problems in the past when using W3 Total Cache object cache or database cache. My recommendation for anyone looking for maximum performance would be to use W3 Total Cache for *page caching* and install the Cloudflare add on for W3 Total Cache and use Cloudflare to handle JS/CSS minification, compression and browser caching settings.

      Reply

  3. bryantech
    May 13, 2015 @ 3:32 pm

    when i run this SQL command.

    alter table wp_postmeta add index woocommercespeed1 (post_id, meta_key, meta_value);

    I get this error

    Error

    SQL query:

    alter table qmdz_postmeta add index woocommercespeed1 (post_id, meta_key, meta_value)

    MySQL said: Documentation
    #1170 – BLOB/TEXT column ‘meta_value’ used in key specification without a key length

    Can you help?

    Reply

    • Dave Hilditch
      May 13, 2015 @ 3:48 pm

      Hi – this can happen.

      Change the command to:

      alter table wp_postmeta add index woocommercespeed1 (post_id, meta_key, meta_value(20));

      Reply

  4. Dave
    May 23, 2015 @ 11:04 pm

    Hi Dave,

    Do you still offer optimization services?

    Thanks,
    Dave

    Reply

    • Dave Hilditch
      May 27, 2015 @ 3:06 pm

      Yes we do – use the contact page or the request a quote page to get in touch for pricing. Please provide as much info as you can.

      Reply

  5. mike ozman
    December 29, 2015 @ 1:50 pm

    my site s hosted on vps server and wpallimport takes for ever to process 50 k records = 5k products . it takes about 20 hrs to process this little . thanks for your optimization service in advance. take care and waiting your reply

    Reply

    • Dave Hilditch
      January 5, 2016 @ 3:47 pm

      Hi – if you have 50k records, 5k products this presumably means an average of 10 variations per product?

      Do you have a lot of metadata for the products too?

      How frequently are you processing the 50k records? Are you on the mercury stack or plain old Apache?

      Reply

Leave a Reply