too slow search "State"

Hi JOhnyBlaze,

Sorry you ran into issues here.

I need to understand a little bit more before I can try answering the question. Can you tell me:
– Are you running on shared hosting?
– What version of AWPCP?
– What version of WP?
– Do you have regions installed?
– Are other searches slow too, or just the state?

Let me know and we’ll go from there!

1. Yes
2. 3.3.2
3. 4.0.1–pl_PL
4. no
5. just state

Hi JohnyBlaze,

Unfortunately, if you’re running on shared hosting, you’re probably starting to hit the limits of your resource allocation, which is the true cause of the problem. AWPCP does require a reasonable level of resources to perform its tasks–and we’re more data and display intensive than most plugins because we have a lot to do.

Here’s an article about shared hosting and why it’s a problem (it’s written with AWPCP and our sister plugin both in mind): https://businessdirectoryplugin.com/support-forum/faq/what-kind-of-hosting-should-i-use-for-wordpress-and-why-is-shared-hosting-a-problem/

This is answer from shared hosting:

“parameter is exceeded the maximum script execution time, which results in an error. I suggest you verify the database queries and execution oh optimization to solve the problem.”

When I made import from another mysql database, has not been completed a few cells, it can have an impact? (once in a while the lack of city, state, etc.).

Hi JohnyBlaze,

Yes, what they are saying is correct–shared hosting with a resource-limited database will indeed behave like that–truncating queries because the resources aren’t available to run them (CPU, RAM) to completion. That’s a problem with shared hosting, not AWPCP per se.

We are a data-intense plugin, trying to do things most plugins do not do at all. We need a reasonable level of CPU and RAM to execute things, particularly searches, as these tend to require more horsepower in your database to complete. We generally recommend 256MB of RAM minimum with your site, but more is always better. And as you add more listings, the problem only gets worse. A “reasonable” site would probably start around 1GB of RAM to ensure that you have enough to handle peak capacity as your data set grows.

this is wrong:

SELECT count(*) FROM itt_awpcp_ads WHERE disabled = 0 AND itt_awpcp_ads.ad_id IN ( SELECT ad_id FROM itt_awpcp_ad_regions WHERE state LIKE ‘%Wielkopolskie%’ ) AND payment_status != ‘Unpaid’ AND verified = 1 AND disabled = 0

Query like this:

SELECT * FROM itt_awpcp_ads ads
inner join itt_awpcp_ad_regions regions
ON ads.ad_id=regions.ad_id
WHERE ads.disabled = 0
AND regions.state LIKE ‘%Wielkopolskie%’
AND ads.payment_status != ‘Unpaid’
AND ads.verified = 1
AND ads.disabled = 0

and the problem disappears

Hi JohnyBlaze,

Both queries are legal, but we’ll investigate why yours works better.

Ok meanwhile .. can I ask for improving the plugin? or indication of where the file in which to make a change?