Support » Plugin: Advanced Woo Search » Please create index on aws_index

  • Resolved Barry


    Hi! Can you please add an index on (at least) the id field of the aws_index table. without it, all queries have to do a full table scan and can be very slow. Specifically we notice problems with DELETE FROM wp_aws_index WHERE id = '$id' which causes replication lag due to the length of time each query takes to complete. Thanks!

    • This topic was modified 4 months ago by Barry.
Viewing 1 replies (of 1 total)
  • Plugin Author ILLID



    Sure, will do this for the next plugin release.


Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.