WPFTS Pro Main Site WPFTS Community Forum
    • Recent
    • Tags
    • Popular
    • Register
    • Login
    1. Home
    2. Giovanni
    Get WPFTS Pro today with 25% discount!
    G
    • Profile
    • Following 0
    • Followers 0
    • Topics 1
    • Posts 1
    • Groups 0

    Giovanni

    @Giovanni

    0
    Reputation
    45
    Profile views
    1
    Posts
    0
    Followers
    0
    Following
    Joined
    Last Online

    Giovanni Unfollow Follow

    Latest posts made by Giovanni

    • Very slow search query on large wordpress site

      I have the last version of plugin (v1.26.67).
      The table wpftsi_index have 650K rows
      The table wpftsi_vectors have 34M (millions) rows
      I use mysql8 on a server with 12 core and 64GB of memory.
      When the user make a search with more then 2 or 3 terms the db server hang.
      There's a way to simplify the JOIN query and avoid the LEFT JOIN for each search term?

      Something like:
      where (w1.word like "matisse%" OR w1.word like "picasso%")

      Now the plugin make a LEFT JOIN for each search term:
      LEFT JOIN ( select .... where (w1.word like "matisse%") group by ds1.id order by NULL ) t1 on t1.id = tbase.id
      LEFT JOIN ( select ... where (w1.word like "picasso%") group by ds1.id order by NULL ) t2 on t2.id = tbase.id
      where ....

      Thanks.
      Giovanni.

      posted in Bugs and Fixes
      G
      Giovanni