Webshop crashes when doing search

Hello,

We are currently working on a new plugin version that will have performance fixes and also will include special performance options.

For now there are several steps that can be made to decrease database load and make search queries faster.

1. Disable search for archive pages from the plugin settings page.
2. Disable all search sources that you don’t need from the ‘Search in’ option.
3. Removing from index all search sources that you are not using.

Please use the following code snippet. You need to add it somewhere outside the plugins folder. For example, inside functions.php file of your theme or use some plugin for adding code snippets like

https://wordpress.org/plugins/code-snippets/. Also, after adding this code, you need to re-index the plugin table.

add_filter('aws_indexed_data', 'my_aws_indexed_data');
function my_aws_indexed_data( $data ) {
    foreach ( $data['terms'] as $source => $all_terms ) {
        if ( strpos( $source, 'meta_' ) === 0 || strpos( $source, 'tax_' ) === 0 || strpos( $source, 'attr_' ) === 0  ) {
            unset( $data['terms'][$source] );
        }
    }
    return $data;
}

This code removes custom fields, taxonomies and attributes of products from the index table. If you need sources to remove or want to leave some of them – please write to me.

4. Do you need to display product variations inside search results? If no than make sure that plugin option ‘Variable products’
set to  ‘Show only parent products’. 
Also please add the following code snippet like in the previous example. Don’t forget to re-index the plugin table.  

add_filter('aws_indexed_data', 'my_aws_indexed_data2');
function my_aws_indexed_data2( $data ) {
    if ( $data['type'] === 'child' ) {
        return false;
    }
    return $data;
}

This can heavily increase search speed and decrease database load.

5. Last solution – change some search behavior. By default the plugin use partial search match.
This means that if, for example, you search for rat plugin will also show the results with words like integration.
So if you don’t turn on ‘Exact match’ search option from the plugin settings page you can use the following snippet.
By using it when searching for rat you will see results only with these words or words that start with rat ( for example rational ).
This can heavily decrease database memory usage.

add_filter( 'aws_search_query_array', 'my_aws_search_query_array' );
function my_aws_search_query_array( $query ) {
    global $wpdb;

    $regex = "/LIKE '%(.*?)%'/is";

    $query['relevance'] = preg_replace( $regex, "LIKE '$1%'", $query['relevance'] );
    $query['search'] = preg_replace( $regex, "LIKE '$1%'", $query['search'] );
    $query['having'] = preg_replace( $regex, "LIKE '$1%'", $query['having'] );

    $regex = "/LIKE '{.*?}(.*?){.*?}'/is";

    $query['relevance'] = preg_replace( $regex, "LIKE '$1%'", $query['relevance'] );
    $query['search'] = preg_replace( $regex, "LIKE '$1%'", $query['search'] );
    $query['having'] = preg_replace( $regex, "LIKE '$1%'", $query['having'] );

    return $query;
}

But i couldn’t find this: “4. Do you need to display product variations inside search results? If no than make sure that plugin option ‘Variable products’
set to ‘Show only parent products’.”
Maybe it is for premium only?

Yes, this option only for PRO plugin version that has feature to display product variations as search results.