4 Comments

  1. Vlad
    June 2, 2017 @ 6:46 pm

    Great info,thanks!Also thanks for all the good info shared on WPIntense,trully is a goldmine of no bullshit actionable stuff.I’ve set up my DIgital Ocean server in no time based on your articles,and with over 150k products on cheapest droplet my site is fast as hell.

    The only thing that troubled me was search for that amount of posts on low performance vps,even for stronger ones WP is notoriously bad in that segment.Based on your video about FullText search i looked and looked around for the right solution and finaly found ElasticPress (elasticsearch) and its pretty good! I havent dig into fine tuning or related posts,autosuggest functions and all of that yet,but its realy eciting powerful tool.

    Cheers mate,thanks again for all the good stuff!

    Reply

    • Dave Hilditch
      June 2, 2017 @ 10:21 pm

      Hi Vlad and thanks for your kind words – I’m aware of the poor default performance people are seeing from free-text search. ElasticPress is good if you’re comfortable installing and maintaining an Elastic Search cluster, or you can use their hosted version starting at $300pcm. It has some downsides – firstly, storage size is large, secondly, index builds can take a while, thirdly there will always be a lag between products being added and being present in your database and finally it increases your maintenance costs and potentially server costs. They encourage you to use a cluster for ‘large’ indexes, where large to them is only 100,000 documents or so. It’s also RAM hungry, ideally needing 16GB RAM.

      Currently, you’ll probably be interested to know, I have in development a little alternative plugin called Super Speedy Search. It uses multiple full text indexes directly on the MySQL tables (Innodb or MyISAM). That means nothing new to learn, no lag, no extra hardware costs, no monthly costs etc.

      It’s fast – like 150ms response time for any text search against a DB with 800,000 products.

      I’m still working on it – the visual aspects, and compatibility with every theme – but it’s so fast that I’ve made it search as you type. So, as you type, the WooCommerce products update immediately in the archive using Ajax.

      I don’t want to give you a release date as I prioritise client work first, and I can’t predict that arriving on my plate, but it should be out this month.

      Reply

      • Vlad
        June 4, 2017 @ 11:06 am

        Super Speedy Search sounds like a much better option than maintaining elastic search i agree,i thought it would be walk in the park to find some good, out-of-the-box fulltext search plugin but that was not the case, so ES sounded like a best solution at the moment..Although i must be fair – setting up ElasticPress is quite easy,it still demands installing ES server tho, but building index is on the click away – that said – any kind of further customization of indexes and other options like auto-suggest,related posts etc require decent amount of knowledge and time..so it can be overwhelming for regular users without RestAPI,database knowledge like me.

        Unfortunately iv deleted my test site with 150K products so i cant check my index size,but ill be focusing on ES storage/RAM usage once i get it all up in few days.

        Looking forward to learning more about Super Speedy Search, im subscribed and will keep my eye on anything new from WPintense.All the best Dave!

        Reply

  2. Vlad
    June 4, 2017 @ 11:05 am

    Super Speedy Search sounds like a much better option than maintaining elastic search i agree,i thought it would be walk in the park to find some good, out-of-the-box fulltext search plugin but that was not the case,
    so ES sounded like a best solution at the moment..Although i must be fair – setting up ElasticPress is quite easy,it still demands installing ES server tho, but building index is on the click away – that said – any kind of further customization of indexes and other options like auto-suggest,related posts etc require decent amount of knowledge and time..so it can be overwhelming for regular users without RestAPI,database knowledge like me.

    Unfortunately iv deleted my test site with 150K products so i cant check my index size,but ill be focusing on ES storage/RAM usage once i get it all up in few days.

    Looking forward to learning more about Super Speedy Search, im subscribed and will keep my eye on anything new from WPintense.All the best Dave!

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

  • Hullo and welcome! Chat directly to the site owners below.
Latest Message: