WordPress iyo MySQL: Waa Maxay Eraygaagu Tiriyaa?
Waxaa jiray hadallo ku saabsan baloogyada oo ku saabsan celceliska eray tirinta ee boostada WordPress. Qaar ka mid ah iftiinka ayaa daatay in makiinadaha raadinta ay kaliya miisaami doonaan saameynta kuwa ugu horreeya x tirada jilayaasha, halka x hadda aan la aqoon. Natiijo ahaan, wax kasta oo intaa ka dib si fudud u ah luminta ereyada.
Anigu waxaan ahay qof si xushmad leh ula socda qoraaladayda blog-ka sidaa darteed waxaan sameyn doonaa falanqeyn dheeri ah oo aan arko bal in caannimada boostada natiijooyinka raadinta ay xiriir la leedahay eray tirinta. Ma heli doono cilmi saynis badan, laakiin waxaan rabaa in aan si qoto dheer u eego.
Sideen ku weydiin karaa WordPress-ka Tirinta Ereyga?
MySQL malahan shaqo kumbuyuutar tirinta shaqeynta MySQL, laakiin sida su'aal kasta oo kale oo aan jawaab loo helin, nin caqli badan oo kujira barta internetka ayaa horey uga jawaabay sida loo isticmaalo MySQL si loo helo Tirinta Ereyga.
Waa tan weydiinta erayga qoraaga ee wax looga beddelay keydka WordPress:
SELECT `ID`, `post_date`, `post_type`,
SUM( LENGTH(`post_content`) - LENGTH(REPLACE(`post_content`, ' ', ''))+1) AS 'Wordcount'
FROM `wp_posts`
GROUP BY `ID`
HAVING `post_type` = 'post' AND `post_status` = 'publish'
ORDER BY `post_date` DESC
LIMIT 0, 100
Waqtigan xaadirka ah kamaqorna 'cabirka boostada ee qumman' tan iyo waxa run ahaantii culeyska siiya mashiinka raadinta ma aha erayga tirinta, laakiin tirada xiriirinta nuxurkaas. Haddii aad haysatid 2,000-erey boostada soo jiidata dareenka isku xidhka badan, markaa cabirka saxda ah ee qoraalkaagu wuxuu ahaa 2,000 eray.