Support » Plugin: Ajax Search Lite » Search by _sku slow down the result.

  • Hi

    I get the result in 1 second for ‘Search in custom post types’ “product” only.

    this turn to 6-10 seconds if i choose ‘..or search in selected custom fields?’ “_sku” option under Sources & Basics.

    Help me how to gain the same performance “1 sec” with _sku custom field for a woocommerce site which has 6000+ products in the database.

Viewing 1 replies (of 1 total)
  • Plugin Author wpdreams

    (@wpdreams)

    Hi,

    Unfortunately I don’t think there is any way to make it faster in that case. Searching custom fields requires a table join operation, which can be very resource heavy, especially in cases where there are many products or many custom fields per object.

    Within the pro version there is an index table engine which allows pre-indexing these fields, but that feature is not yet implemented into the free one. It will be in a future release.

Viewing 1 replies (of 1 total)
  • The topic ‘Search by _sku slow down the result.’ is closed to new replies.