[optimalpartners]

Thank you for the response. Yes, wordpress was not made to deal with very large data sets. Our wp_asp_index table as 3 500 000 records. It is a lot.

We are also having problems with another query in related posts plugin:

SELECT
wp_posts.post_title as title,
wp_posts.ID as id,
wp_posts.post_date as date,
wp_posts.post_content as content,
wp_posts.post_excerpt as excerpt,
” as author,
wp_posts.post_type as post_type,
(SELECT DISTINCT GROUP_CONCAT( wp_term_taxonomy.term_id SEPARATOR ‘,’ ) FROM wp_term_taxonomy
LEFT JOIN wp_term_relationships ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
WHERE (wp_term_relationships.object_id = wp_posts.ID) ) as ttid,
((case when
(wp_posts.post_title LIKE ‘%yammer%’)
then 10 else 0 end) + (case when
(wp_posts.post_excerpt LIKE ‘%social%’)
then 6 else 0 end)) as relevance
FROM wp_posts
LEFT JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID

WHERE
(wp_posts.ID <> 162672) AND
(wp_posts.post_type IN (‘dummy_notting’,’post’,’page’,’articles’,’resources’,’wprss_feed_item’,’web-resource’,’peer’,’consultant’)) AND
(
NOT EXISTS (SELECT * FROM wp_term_relationships as xt WHERE xt.object_id = wp_posts.ID)
OR
wp_posts.ID IN (
SELECT DISTINCT(tr.object_id)
FROM wp_term_relationships AS tr
LEFT JOIN wp_term_taxonomy as tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE
tt.term_id NOT IN (61)
AND tr.object_id NOT IN (
SELECT DISTINCT(trs.object_id)
FROM wp_term_relationships AS trs
LEFT JOIN wp_term_taxonomy as tts ON trs.term_taxonomy_id = tts.term_taxonomy_id
WHERE tts.term_id IN (61)
)
)
) AND
(1) AND
((1)) AND
wp_posts.ID NOT IN (1070, 815, 1345, 1319, 33753, 34547) AND
(wp_posts.post_status = ‘publish’) AND
(( wp_postmeta.meta_key=’wpcf-special-excerpt’ AND wp_postmeta.meta_value LIKE ‘%social%’ OR wp_postmeta.meta_value LIKE ‘%network%’ ) OR ( wp_posts.post_title LIKE ‘%yammer%’ OR wp_posts.post_title LIKE ‘%enterprise%’ OR wp_posts.post_title LIKE ‘%social%’ ) OR ( wp_posts.post_excerpt LIKE ‘%social%’ OR wp_posts.post_excerpt LIKE ‘%network%’ ))
GROUP BY wp_posts.ID
ORDER BY relevance DESC, wp_posts.post_date DESC
LIMIT 7

This one, using explain in mysql, give me a first select with +70 000 results.

So, I believe there is not much that can be done here.

Thank you again for the assistance.

[optimalpartners]

Yes it dose seam to work.
Thank you very much. It would wave taken me some long hours to figure this out on my own.

[optimalpartners]

Hello, we have updated the related posts pro plugin to 1.5. Unfortunately the symptoms have not changed.

[optimalpartners]

You cannot access this content.

[optimalpartners]

Thank you for your help, I was able to find the error and fix it. One other question I have is that the search seems very slow. We’ve done a lot to increase the speed of our site, however, I’m wondering if there is anything we can do to increase the speed of the search. I’ve looked into the index option however because we have a number of feeds being pulled in that are searchable, I don’t think the index option will work for us. Thank you again for your help!

[optimalpartners]

Ok thank you so much. Also just curious if there is any way to allow for special characters in search terms? We had someone testing the search and she tried using &
I realize it could be an issue because of the code, as I noticed anything after the & was not searched. Not a big issue, just thought I’d check.

[optimalpartners]

Just a couple quick questions. A few things came up in testing and we were wondering if you have a target date or estimate date for:
-filter settings staying the same after going to the search (including if its a different search instance, such as from my jobs page, the main search page shows the main search always)
-grouping results on the search page/prioritizing types of results, (maybe even sorting those types of results once on the search page?? that I realize might be a stretch, but definitely would be a cool feature!)

Also, just curious if we can have the custom post type selectors under front end search settings show above the “default values” (which in our case we are just using pages)

Also as a side note, if you aren’t aware of what might be causing this problem, it’s ok since we will probably be copying our development site over anyway, but on our production site, search works perfectly. On development for some reason the preview results work, but on the search page, it comes up with several page numbers and doesn’t show any results. Seems strange. But like I said we should be refreshing our development blog with the functioning production blog soon if you are unable to determine what the problem is.

Also I left a review for you on codecanyon. Thank you again for all your help! =)

[optimalpartners]

Thank you so much, you’ve been a huge help! Everything is working on both my development and production sites.

One other question is regarding the filters. When I select certain filters and then search, if I want to search again with the same settings I have to re-select what I’m looking for. I could not find a setting to save the search settings, but I’m wondering if there is a possibility for that to be a future enhancement. Also similar is when I search from my separate jobs page that has a separate search, once you search it sends you to the search results page and the normal full site search shows there. Any recommendation so that we can keep the search form that they searched from?

[optimalpartners]

Hi, sorry for the late response, we’ve been working on lots of different features. We actually decided not to include the jobs search in our main search, so that resolves one issue. The other issue with the separate jobs search, and after updating to the newest version of the plugin, I somehow got it to work properly on our development site, so I imported the search instance (after updating the plugin on development) and tested and now I’m not getting any results. At first I noticed some of the settings were different, for example some of the excluded taxonomy terms were included, so I changed that and I’m getting no results.

Also just to clarify, the customization was in order to have the categories and post types work exclusively of each other as filters if I understand correctly. That doesn’t seem like we need that anymore because of the filters we are now using. If you let me know what to change back I can make the change. I do not want a customization which we may not need to be causing some of these things to be breaking.

Thank you for all your help!

[optimalpartners]

Just following up on this, wondering if you had a chance to take a look

[optimalpartners]

It looks like that helped, however I noticed I still get one result in the first few results that is not from that feed, it is from another. And when I keep looking to the next pages of results I’m noticing more results from non-jobs feeds.

Also, I was testing search on the production side and noticed in the main search that the results that come up in the preview differ from the ones in the main search results page. I’ve attached a screenshot, but for example I tried using the filter to search for jobs and got some results but then the full results page had no results. I tested all other filters and the Jobs filter is the only one that isn’t working properly. All the others return results. If you need access to the production site, you can use the same information as posted originally at blog.optimal-partners.com

[optimalpartners]

Thank you! It’s working!

I’m also looking to have a separate instance of the search to only search through “Jobs” these are a category of WP RSS feed items. Right now it is configured to search through the feed items, but I can’t get it to only search that one category. Any suggestions? Here’s the page that the jobs search is located: http://blogdev.optimal-partners.com/feeds/

[optimalpartners]

Thank you so much for all the help!! It works great!

My question now is what is the best way to move it from our development environment into production? I tried copying the plugin file over to the production directory hoping that all of my settings would stay the same, but it seems to be a brand new copy of the plugin. Is there an easy way to move it over?

Also once the search is moved over, I’m going to be working on having separate instances of the search for specified custom post types, I mentioned a few messages back about custom fields not being searchable.

Thank you again!

[optimalpartners]

Thank you so much!

For #9, It’s actually only an issue within the AJAX results (see the screenshots from the 12/16 post) Those “types” of content are more for behind the scenes and should not be coming up in results, I’m not sure why they are coming up now when originally they didn’t. (I also can’t find where to exclude them as they aren’t listed in the normal exclude section)

[optimalpartners]

Hi, I just wanted to make sure this issue didn’t get buried. There were several issues I mentioned above in a post from 12/16 that I think were missed. These issues are very important as we think we are very close to moving the search to our production site, however we want to make sure these issues are cleared up first. Also there was some clarification I made about the custom fields for searching through the details on our custom post types. I know with the holidays things can get busy and I just wanted to make sure this didn’t get lost. Thank you again for all your help!

[Author]

Posts