Excellent and Free

Thank you for the review. The cache is not enabled by default. You need to enable this in the settings page. But it is highly recommended especially with those many posts that you have on your blog

I have a multisite installation. When I activated the plugin, a large process was started, the browser starts to wait, so I refreshed the page. I went to plugin-activator.php file and delete:

crp_delete_index();
crp_create_index();

Then, I could activate the plugin without problems.
I thought the process was the cache generation.

That’s actually the index creation for the fulltext index. Given the huge number of posts on your site, I suggest (if not done already) running the queries at the bottom of the settings page in phpMyAdmin or equivalent directly.

Understood, thank you.
So, an improvement can be not to create the fulltext index automatically after activated, but through a button or ticket, that way, in the sites with many posts, the index would be created slowly in a dynamic way, with minor impact on the server processes.

In the same field,
there is a way to clear the fulltext index if I uninstall the plugin?

• This reply was modified 7 years ago by Marlimant.

That is my plan. Am likely going to put a max number of posts below which the fulltext index will be created automatically (probably 1000) post which it will need to be created manually.

Issue is that the plugin will not pull proper relevant posts without the related posts index so will need a big warning in the posts screen

Thanks for the answer Ajay.

Two questions:

1) The fulltext index will be cleared when I uninstall the plugin or will remain in the database forever? There is any way to clear the fulltext index tables?

2) If you can help me with the Sql query… What I need to put in PhpMyadmin to create a fulltext index based on 1000 post only?

Best regards,

Javier.

1) Yes, it will be deleted. You can just delete it via phpMyAdmin as well if you want.

2) I’m not aware that this can be done. It’s a fulltext for the entire table

Thank you for all answers Ajay.
You can see your plugin in action on https://www.extranoticias.cl

This is my CSS if you want to share it or something:

.crp_related{max-width:96.6%; margin: 0 0 40px 0;}
.crp_related h3{font-size:17px; margin: 60px auto 16px;}
.crp_related ul {background: #f1f1f1 none repeat scroll 0 0; border: 1px solid #dedede;  display: table; float: none; margin: auto; padding: 15px 15px 16px 0; width: 100%; table-layout: fixed; /* optional */}

.crp_related li {float: none; width: auto; text-align: center; hyphens: auto; list-style: outside none none; display: table-cell; overflow: hidden;}

.crp_related img{background:transparent url("https://www.extranoticias.cl/wp-content/themes/Extra_Noticias_Wide/images/fallback3.jpg") no-repeat scroll 0 -4px; background-size:cover; -webkit-background-size:cover; box-sizing: border-box; color: transparent; display: inline-block; margin: 0 0 6px 0; min-height:130px; min-width:204px; max-width:204px; vertical-align: top; }

.crp_related a {display:block; color: #282828; font-size: 13px; -webkit-hyphens: auto; -moz-hyphens: auto; hyphens: auto; line-height: 16px; margin: 0 0 0 14px; }
span.crp_title{max-width: 218px; display: block; text-align:left;}
span.crp_title::first-line{color:#505050; font-weight:bold;}

@media only screen and (max-width:587px){
.crp_related{margin: 0 0 40px -4px;}
.crp_related li {display: table; margin: 0 auto;}
.crp_related img {margin:26px auto 7px !important; max-height:unset !important; max-width:400px !important;}
.crp_related a {font-size: 14px;  line-height: 17px; }
span.crp_title {max-width: 400px;}

}

Is this Noticias Relacionadas: It looks pretty good.

Yes it is! Thank you.