Related posts, not related?

Couple of things to try:

a) Disable the cache
b) Recreate the index
c) More advanced here: Use phpMyAdmin to change the table type from either myiSAM or InnoDB
'ALTER TABLE wp_posts ENGINE=MYISAM;' or 'ALTER TABLE wp_posts ENGINE=InnoDB;'

Hello,

I have the same issue on my site. I have tired other plugins but this one seems to do basically what i want, however the “Non Related Posts issue” is now becoming a problem.

I have done the a) & b) above, but as i do not fully understand what c) is supposed to do coudl you offer some explanation please?

Thank You

John

c basically changes the mysql engine for the wp_posts table which holds the content. Depending on if it is myISAM or InnoDB, you could potentially have different results.

One additional thing to try is to use my add-on plugin called CRP Taxonomy which allows you to add another setting to restrict by tags adding another degree of relevance.

Hello,

Thank You for your response.

I implemented the additional Plugin and it seems to have made a positive difference, but i am not sure how effective it really is as is seems to be based on a very ” binary” logic/// OK it is better than what it was, but i am not sure if it suits my implementation…i will continue to monitor this in the next week or two.

One question can i ask why this additional functionality is an additional plugin and not a feature upgrade to the original Plugin.

The other option of changing the mysql engine i have not been able to do as i cannot seem to get the SQL command to work and i have an outstanding question with my Hosting Company on this one.

Thanks

John

Hello,

Just realised my mistake with regard to why i could not get the Commend to work to change the mysql engine.

The command works with a Table not as i was trying to do with the whole database…..

I have since learnt that having a mixed sql engine situation within a database is not recommended, so unless there is an extremely important reason to change to MYISAM, i will not implement that option at this time.

thank you

John

Hi, from my reading, having different engines per table isn’t incorrect. See this from existing users who have chosen different engines for different uses: https://dba.stackexchange.com/questions/385/is-it-common-practice-to-mix-innodb-and-myisam-tables-on-same-server or https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html

As for why an add-on. It’s because that’s the direction that this plugin will be headed. Through a mix of feature specific addons (both paid and free)

Hello,

Apologise for the delay in getting back to you on this.

Ok I have updated the engine on the wp_posts table which seemed to work without any issues, and i have carried out some checks on the web site performance including the use of GTmetrix and there does not seem to be any adverse effects of introducing “mixed” SQL engines into the same database. but i am not sure how and where any impact would be seen?

I have carried out a number of basic checks using your Setting page to alter the parameters and i cannot seem to get much change between the old Database engine and the new version????

I also not that the most significant positive difference is when i use the parameter that are introduced by the CRP Taxonomy plugin mainly Select by Category and Tag, which would appear to override any intelligent matching of text within the respective posts. but i may be totally off message with my analyse at this point.

Do you offer any guidelines in respect of Content messaging that your algorithms are looking for in terms of making relevant matches please?

Please note that i have Title and text selected and i am only looking at the 1st 500 word in a post, if that makes sense ???

Again, thanks for your assistance. the plugin is still the closest to what i am looking for, so thanks for all the work and the continued help.

John

The plugin using mySQL’s inbuilt algorithm to weight the content and posts. There is no fixed logic that applies to every single site. It’s a tweak and see what it works e.g. the number of words above or if you want to use the content and title or just the title.

The add-on adds the extra level of checking because it limits the already matched posts to the same taxonomy.

Ajay,

Thank you for your response, and the time taken to review my comments.

John

You are most welcome