We are now approaching close to 7,000 business listings on our site and the search function on the front end is just TOO SLOW. Example: It takes approximately 10 seconds to search the word “gutters” or “windows”. Currently we only have quick search to search within “Business Name”, “Business Tags” and a custom field called “Labels”. With a database this large, running even a minimal search query can bog down the server. We have dedicated resources of 2 CPUs and 2 Gigs of RAM. I’m not sure if that’s exactly the problem, though it very well could be. I would rather not setup something like ElasticSearch, if there’s a less intrusive alternative. I have optimized the database and minimized duplicate words and phrases within the “business tags”.
Any suggestions or tips would be appreciated.
Update!!! I just discovered something interesting. If I only have “Business Name” and “Business Tags” checked “ON” then it speeds up my search… for example: “gutters” to 1-5 seconds instead of 10+seconds. That third selection is bogging it down. What’s odd is, I rarely even use the custom “labels” field. I only use it for alternative business names, like “Harry’s Steak House”, I’ll put alternative “Harrys Steakhouse” in labels. Not sure why this is causing such a resource issue.
Thanks for the information. It’s also possible that you have a plugin or theme conflict on your hands. So I’d suggest trying this test for theme and plugin conflicts with Business Directory to see if you can find the cause:
If that doesn’t help, please contact us with WP admin and FTP credentials to your site and we’ll see what we can do.
We need the following information to debug the issue:
– WP admin username
– WP admin password
– WP login URL
– FTP username
– FTP password
– FTP servername/IP address
Contact us here with that info and a link to this forum thread:
Most Users Ever Online: 325
Currently Browsing this Page:
Guest Posters: 5336
Newest Members:Philos Mudis
Moderators: BD Support: 3
Administrators: Business Directory Support: 1720