WordPress da MySQL: Menene Maganar Ku?

Sanya hotuna 16207113 s

An yi magana kan shafukan yanar gizo game da matsakaicin girman rubutun WordPress. An ɗan haskaka cewa Injin Bincike zai auna tasirin na farkon ne kawai x yawan haruffa, inda x a halin yanzu ba a sani ba. A sakamakon haka, duk wani abu bayan wannan kawai lalata kalmomi ne.

kalma

Hoton daga Kalma!

Na kasance abin birgewa tare da rubutun gidan yanar gizo don haka zan yi ƙarin bincike kuma in ga idan sanannen post ɗin daga sakamakon bincike yana da alaƙa da kalmar ƙidaya. Ba zan sami ilimin kimiyya sosai ba, amma ina so in zurfafa tunani.

Ta yaya zan iya tambayar WordPress don Countidaya Kalma?

MySQL bashi da aikin ƙididdigar ƙididdigar kalma don MySQL, amma kamar yadda yake tare da kowace tambayar da ba a amsa ba, wani mai wayo a cikin shafin yanar gizon ya riga ya amsa yadda ake amfani da MySQL don samun Kalmar Kalma.

Anan tambayar tambaya ta marubucin da aka gyara don ajiyar bayanan WordPress:

Zabi ʻID`, `` post_date`, '' post_type`,
SUM (LENGTH (`` post_content`) - LENGTH (SAURARA ('' post_content``, '',))) + 1) AS 'Wordcount'
DAGA 'wp_posts'
GROUP BY ʻID`
KASAN 'post_type` =' post 'DA' post_status` = 'buga'
TAMBAYA TA 'post_date` DESC
LIMITI 0, 100

A halin yanzu bana biyan kuɗi zuwa 'cikakkiyar girman matsayi' tunda abin da gaske yake samar da nauyi tare da injin bincike ba kawai kalmar lissafi bane, amma yawan hanyoyin haɗin yanar gizon. Idan kana da sakon rubutu na 2,000 wanda ke jan hankalin mahada da yawa, to madaidaicin girman matsayin ka kalmomi 2,000 ne.

7 Comments

  1. 1
  2. 2
  3. 3

    Na yi rubutu har sai na fahimci abin da zan fahimta. Ina tsammanin wauta ce cewa mutane suna siyan abun ciki suna lulluɓe da ƙididdigar kalma.

    • 4

      Casey - Na yarda da ku kwata-kwata. Ina tsammanin akwai dama don amfani da hotuna da harsunan harshe don jawo hankulan mutane don karantawa ta cikin abubuwan, amma na rubuta har sai ina ganin an kawo batun… kuma ina kokarin yin ba ko kadan.

    • 5

      Casey - Na yarda da ku kwata-kwata. Ina tsammanin akwai dama don amfani da hotuna da harsunan harshe don jawo hankulan mutane don karantawa ta cikin abubuwan, amma na rubuta har sai ina ganin an kawo batun… kuma ina kokarin yin ba ko kadan.

Me kuke tunani?

Wannan shafin yana amfani da Akismet don rage spam. Koyi yadda aka sarrafa bayanan bayaninka.