Plugin Search&Filter Pro loading time takes a lot of time

Trevor

#55365

Ionut

It should not be taking that time unless your site is huge. But, you say this is a development environment, so I cannot see the problem?

Anonymous

#55459

This reply has been marked as private.

Trevor

#55471

Ionut

I am in the UK, so unless you are as well, I think Skype voice would be best. Are you in Cluj?

Does this delay happen if Ajax is off?

Anonymous

#55476

This reply has been marked as private.

Trevor

#55477

I have sent a contact request to you

Trevor

#55482

OK, after our Skype call, you were going to:

1. Install the new 2.2.0 version (you had 2.1.2 on the system). You will use ftp to do this.
2. Check the S&F Status report in that new version.
3. Inquire as to the specs of your in-house server:
3.1. Server PHP memory. At least 256M please
3.2. Disc drive? Hard disc or SSD. If Hard Disc, is it RAID?
3.3. What version of PHP?

Whilst we spoke, I showed you how to increase WP memory to 128M by editing the wp-config.php file. Note that this will only work IF PHP has sufficient memory to allocate.

I will wait for you to get back to me, here or on Skype.

Trevor

#55732

Hi

Are you able to add the Query Monitor plugin so we can see what is taking the time? I have a horrible feeling that something on the server is the issue, but we will see.

Anonymous

#55813

Hello Trevor,
I managed to find why the request to the db takes so long and also which are the query that are responsible, so below are the files and also the queries :
1) – wp-content/plugins/search-filter-pro/public/includes/class-search-filter-cache.php:1344 time is 4.4 seconds
Query is : SELECT post_id, post_parent_id, field_value_min, field_value_max

FROM (SELECT min_table.post_id as post_id, min_table.post_parent_id as post_parent_id, min_table.field_value as field_value_min, max_table.field_value as field_value_max

FROM (SELECT post_id, post_parent_id, field_value

FROM wp_search_filter_cache

WHERE field_name = ‘_sfm_mf_2’) AS min_table

LEFT JOIN (SELECT post_id, field_value

FROM wp_search_filter_cache

WHERE field_name = ‘_sfm_mf_2’) AS max_table

ON min_table.post_id = max_table.post_id) as range_table

WHERE cast(field_value_min AS DECIMAL(12,2)) >= cast(‘0’ as DECIMAL(12,2))

AND cast(field_value_max AS DECIMAL(12,2)) <= cast(‘540022000’ as DECIMAL(12,2))

This is called for each of the filters that we have.

Please note that on our dev env we had to remove the search & filter pro plugin in order for other tasks to be tested on it. However on tuesday I will put it back on.

Thank you and have a nice day!

Anonymous

#55816

This reply has been marked as private.

Anonymous

#55947

This reply has been marked as private.

[Author]

Posts