Bad performance
-
Looking for an alternative to GeoDirectory but your plugin is extremely slow.
-
Looks like you have performance problems with your server. Try to ask hoster support.
Why marked “Resolved”? Your plugin is repeatedly scanning the Posts table on every page. Will you fix this bug?
There is no problem with my server.
There is not any bug. It does not “repeatedly scanning”, it executes SQL query to filter directory listings by custom post type from WP posts table. And not “repeatedly”, one call – one query.
Not true. My client has hundreds of pages, imagine the negative impact on server performance with these slow LIKe queries. You don’t need these for every requested page. It is a bug.
SELECT ID AS id, post_name AS slug
FROM wp_posts
WHERE (post_content LIKE ‘%[webdirectory]%’)
AND post_status = ‘publish’
AND post_type = ‘page’SELECT ID AS id, post_name AS slug
FROM wp_posts
WHERE (post_content LIKE ‘%[webdirectory %’)
AND post_status = ‘publish’
AND post_type = ‘page’SELECT ID AS id
FROM wp_posts
WHERE (post_content LIKE ‘%[webdirectory-listing-page]%’
OR post_content LIKE ‘%[webdirectory-listing]%’)
AND post_status = ‘publish’
AND post_type = ‘page’SELECT ID AS id
FROM wp_posts
WHERE (post_content LIKE ‘%[webdirectory-listing-page %’
OR post_content LIKE ‘%[webdirectory-listing %’)
AND post_status = ‘publish’
AND post_type = ‘page’These are quite light requests even for millions of records. And this method uses most of plugins through the web.
Please, read wordpress documentation before requesting something, this would be very helpful for your further experience.
What do you mean most of the plugins??? Your plugin is the only plugin that does these stupid things. First you blamed the server and now refuses to admit a bug in your plugin. BTW thanks for your tip on wordpress doc but I am a developer myself so I know what I am talking about.
Do not be so angry. Everything is fine, guy. Peace.
Nothing is fine. Are you going to fix the bug?
kriscronuk I’ve removed your review, name calling isn’t permitted here.
Since you’ve done that step I’m going to go with “that user is done” and close this topic.
The topic ‘Bad performance’ is closed to new replies.