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

  • Resolved Barry

    (@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

    (@mihail-barinov)

    Hello,

    Sure, will do this for the next plugin release.

    Regards

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