: SEO optimization by related content search My case is like this: In a product page there is related products section and we pick products from same category. Simple SQL query , no magic

Posted in: #Seo #SiteSearch #WebsiteDesign

My case is like this:

In a product page there is related products section and we pick products from same category. Simple SQL query , no magic magic

Is it any better to execute similar documents query on full text search instead of this? for both user and SEO? eg: lucene/solr or db full text index

it would be like wordpress related post plugin wordpress.org/extend/plugins/yet-another-related-posts-plugin/ this way related products will contain more common keywords than current product list.

I wonder any usage of this kind of related content in a detail page is helpful for SEO?
I don't need it for users , but is it worth to do for search engines ?

Thanks in advance.

10.01% popularity Vote Up Vote Down

: Phishing attack. Where do I start the cleanup? I'm a newbie webmaster. I've got a domain and a site... and no clue about the web (I'm OK with files and programs... ) I got a message from

@Yeniel560

Posted in: #SharedHosting #Url

2 Comments

: The certificate chain presented by the server should be sorted according to the TLS Specification: certificate_list This is a sequence (chain) of X.509v3 certificates. The sender's

@Yeniel560

0 Comments

: Where do I get sports information for web app development? I'm creating an application for personal use and will be needing sports related information such as previews, scores, and recaps. My

@Yeniel560

Posted in: #Content #Php #WebApplications

3 Comments

: Make browsers not to make HTTP requests for cached items I know that http caching and sending 304 response is to save some bandwidth and of course some load time. However in my web site there

@Yeniel560

Posted in: #Cache #CacheControl #Optimization

2 Comments

Login to post a comment!

1 Comments

Sorted by latest first Latest Oldest Best

@Tiffany637

First off you are going to want to take the product description and remove all of the commonly used words, such as "that", "the", or "and", from the product description. Next you are going to want to take the remaining words to build your query. Here is an example of the query structure:

SELECT *,
MATCH (product_name, product_description)
AGAINST ('puppies kittens rabbits ... hippos') AS score
FROM products_table
ORDER BY score DESC LIMIT 5

I would recommend keeping the number of words you use to compare against other products below 20 to reduce the amount of strain on your mysql server.

10% popularity Vote Up Vote Down

Feed

: SEO optimization by related content search My case is like this: In a product page there is related products section and we pick products from same category. Simple SQL query , no magic

More posts by @Yeniel560

: Phishing attack. Where do I start the cleanup? I'm a newbie webmaster. I've got a domain and a site... and no clue about the web (I'm OK with files and programs... ) I got a message from

: The certificate chain presented by the server should be sorted according to the TLS Specification: certificate_list This is a sequence (chain) of X.509v3 certificates. The sender's

: Where do I get sports information for web app development? I'm creating an application for personal use and will be needing sports related information such as previews, scores, and recaps. My

: Make browsers not to make HTTP requests for cached items I know that http caching and sending 304 response is to save some bandwidth and of course some load time. However in my web site there

Login to post a comment!

1 Comments

Back to top | Use Dark Theme