Hi!
I have logged in via FTP and done some debugging on the queries. Those were not changed in the latest releases, the plugin runs the same exact queries as before. I just confirmed that by debugging the search class, everything is same as it was before – but I may have found something else.
1. The queries were actually running fast enough (from 0.001s to 0.05s interval per query), but I have found something that was clogging up the search performance. So I enabled debug mode, and started running very hard queries for phrases like ‘a b c d e’. This is a very hard search, as it must run 5 separate database queries, that will return a huge number of results. Then find the intersection of the result arrays, which might also be huge (5 x 10k~ items).
What I found that merging and processing these result arrays was actually a very slow process. I have manually lowered a special limit variable (pool size), now I see huge performance improvement because of that.
There was one more thing, but I am not sure about that one yet. Would you mind if I run further test on the plugin on your server in the next couple of days? (4-7 days) I will not change anything on the server, I just want to test out possible changes to the plugin, if that is okay with you.
2. That is not possible in any way unfortunately.
Also, I have checked your wp-confing.php file to see the configuration, and I have found that there was an error with the apostrophes on these lines:
[php]ini_set( ‘upload_max_size’ , ‘300MB’ );
ini_set( ‘post_max_size’, ‘300MB’);[/php]
I have corrected those for you. There was also a missing memory limit ini_set call, while you had the WP_MEMORY_LIMIT constant set. I added this ini_set line below it:
[php]ini_set(‘memory_limit’, ‘1024M’);[/php]
Without this, the WP_MEMORY_LIMIT has no effect (or not always). I hope you don’t mind I added this as well.
I hope I can continue testing the plugin on your site, it has a great amount products to try with, it would help me a lot. Thank you!