We have a concern with the Newspaper Search results is slow in returning any content.
We have WP Super Cache install and have configured this per your documentation.https://forum.tagdiv.com/cache-plugin-install-and-configure/
Please advise.
Hi,
The Search Results can be slow if you have many posts and the server is not dedicate.
What you can do is to use a database cache.
Also, if you want to make the site faster, you can check our guide -> https://forum.tagdiv.com/how-to-make-the-site-faster/
Thank you!
The site is not on a shared server it is on a dedicated AWS server. We have followed your site’s faster guide and are using the WP Super Cache and AWS CloudFront. Here is a video of our Theme Status. https://www.screencast.com/t/4KaFkanKOk.
If you need access to the back end please let me know.
Hi,
Maybe the problem to be because you are using an old theme version. If you have the possibility make a staging and update there the theme to Newspaper v11.4 and see if there are aby improvements.
Also you can make a test using only the theme plugins and see if you got better results. It is possible that some plugins to interfere.
Thank you!
Same here – I’m using super cache
The site is fast, but the search results is extremly slow
Note: the first search is slow and the second search on the same search term is very fast.
Is there anything I need to do to make it faster?
–
See this example in my DEV system:
https://dev2.haipo.co.il/?s=%D7%99%D7%A8%D7%95%D7%9F
Hi haipo, what you can do is to reduce the aria of search in database to posts (add post type post on search element and loop post – https://i.imgur.com/IxFLXqi.png – https://i.imgur.com/5uUIbvP.png also make sure that you are using a proper thumb for images – https://i.imgur.com/fTelJDO.png a big images will slow the results.
Also you can use a Cloudflare (CDN) to speed up the results.
I hope this will help you!
Hi Calin
I did as you said but it didnd help.
I narrowed down to post
Limit to 5 results
Change the image to 300X0
But still the serch is super slow
–
I have my own instalation with fast DB.
You can see here:
https://dev2.haipo.co.il/?s=%D7%99%D7%A2%D7%A7%D7%91
–
Maybe some other idea?
–
Thanks,
Yaron (haipo)
Hi,
You need also to make sure that you have a good host and not a shared one
Checked with the monitor query seems to have some php errors – https://i.imgur.com/Iq4uvdL.png
So what I recommend is to make a test using only tagDiv plugins to see if there are not extra plugin interfering.
Thank you!
Hi Calin
I did many tests, and installed the Query monitor
Can you please recheck your SQL?
I get several warning related to your SQL.
And the search results is extremely slow.
I have my own host and all my DB is in memory.
–
Please be so kind to recheck your SQL here:
https://dev2.haipo.co.il/?s=%D7%90%D7%91%D7%99%D7%94%D7%95
–
I also sent TAGDIV a login details to me DEV site.
–
Thanks,
Yaron
One thing we do on our sites is disable the image preview for the search box. We modify one of the core templates, to comment out the element for the thumbnail. Speeds stuff up waaaay faster.
(I don’t work here.)
Hello,
This – https://imgur.com/Iq4uvdL is not part from our theme, is an extra untested plugin.
Also, to reduce the time you should use for the loop block a different pagination, like numbered, load more button, next/prev, this should reduce the time with 2 seconds.
Thank you!
Hi Calin,
I did as you said:
Disabled Plugin web2application
Removed the images
Reduced to 5 replies in a loop
But still get 6.5 seconds
I tell you that someting isn’t working well
can you please help meon this one?
This is the only bug left in my DEV system, abd it is a “show stopper” before going live with TAGDIV.
https://dev2.haipo.co.il/?s=%D7%99%D7%A2%D7%A7%D7%91
Hi Calin,
When analyzing your search SQL, I see 2 SQLs statements which are very slow
Both of them take ~3 seconds/
Can you look at them please?
–
Query SELECT
Caller
All
Time
Total: 126 / 128 6.0610
38 SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
WHERE 1=1
AND (((wp_posts.post_title LIKE ‘%יעקב%’)
OR (wp_posts.post_excerpt LIKE ‘%יעקב%’)
OR (wp_posts.post_content LIKE ‘%יעקב%’)))
AND ((wp_posts.post_type = ‘post’
AND (wp_posts.post_status = ‘publish’
OR wp_posts.post_status = ‘private’
OR wp_posts.post_status = ‘advanced_ads_expired’))
OR (wp_posts.post_type = ‘page’
AND (wp_posts.post_status = ‘publish’
OR wp_posts.post_status = ‘private’
OR wp_posts.post_status = ‘advanced_ads_expired’))
OR (wp_posts.post_type = ‘attachment’
AND (wp_posts.post_status = ‘publish’
OR wp_posts.post_status = ‘private’
OR wp_posts.post_status = ‘advanced_ads_expired’))
OR (wp_posts.post_type = ‘tdc-review’
AND (wp_posts.post_status = ‘publish’
OR wp_posts.post_status = ‘private’
OR wp_posts.post_status = ‘advanced_ads_expired’)))
ORDER BY wp_posts.post_title LIKE ‘%יעקב%’ DESC, wp_posts.post_date DESC
LIMIT 0, 4
WP_Query->get_posts
Main Query
3.0252
111 SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
WHERE 1=1
AND wp_posts.ID NOT IN (486438)
AND (((wp_posts.post_title LIKE ‘%יעקב%’)
OR (wp_posts.post_excerpt LIKE ‘%יעקב%’)
OR (wp_posts.post_content LIKE ‘%יעקב%’)))
AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘tdc-review’)
AND ((wp_posts.post_status = ‘publish’))
ORDER BY wp_posts.post_title LIKE ‘%יעקב%’ DESC, wp_posts.post_date DESC
LIMIT 0, 4
WP_Query->get_posts
2.9084
The same problem here!
Some very slow SQL queries on the homepage painfully delay loading.
The slowest ones are related to the query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
Where is this used? How can it be solved?
Hi Industria Digital,
The SELECT SQL_CALC_FOUND_ROWS wp_posts.ID are used for rows and blocks (our theme stores the settings from rows and elements in database and the mentioned sql is one of those that make a request to them).
Thank you!
Hello Calin, thank you for your answer, although it is not very helpful to me.
Requests like that are really a real problem and headache. It is very painful and totally inefficient. What can we do to improve performance? Wouldn’t it be more convenient to store and keep those values updated, rather than having to calculate them with each visit? The newspaper is on good hosting and still has the database bottleneck that takes more than 1.8 s to perform all the homepage queries. A horror! What can I do to shovel it until I have a solution? Do you plan to do anything to solve this problem?
Hi,
For the moment those are some suggestions that can help:
– use a cache for database, object cache should help.
– if tagDiv Standard Pack is used, move to cloud and disable the plugin or move from cloud to standard template and disable the cloud.
– reduce the rows number (rows and inner rows) from pages and cloud templates.
– Reduce the number of blocks.
My suggestion is to try first with object cache for database this should resolve the problem.
Thank you!
