The ‘b’ join is very slow

  • Resolved sharespring

    (@sharespring)


    1 year, 3 months ago

    I’ve found that removing the LEFT JOIN as 'b' code sped up my query from >2mins to <1sec. I didn’t notice any negative effects in the search results. Perhaps you can either remove this join if it is unnecessary, or otherwise find a way to optimize it.

Viewing 1 replies (of 1 total)
  • Plugin Author Mateusz Gbiorczyk

    (@mateuszgbiorczyk)

    Hi @sharespring,

    Thank you for your message.

    JEFT JOIN is needed to check whether a given value comes from a specific ACF field type. In the case of slow databases that have a huge number of records in the wp_posts and wp_postmeta tables, performance may be lower. Unfortunately, there is no way around this – this is a limitation of how WordPress stores data. Everything is practically in two tables and this makes more complex queries slow.

    With the default plugin settings, the search is very accurate and works quickly, unless the database is huge. Your database probably contains a lot of records. Please try to activate Lite Mode in the plugin settings – this should solve your problem.

    Best,
    Mateusz

Viewing 1 replies (of 1 total)
  • The topic ‘The ‘b’ join is very slow’ is closed to new replies.