Cite ceva despre continutul platit

Lucrarea timpului asupra contractelor imi ingaduie sa va ofer ceva informatii statistice zic eu interesante apropo de chestia asta cu continutul platit.

Asa cum va puteti inchipui, exista undeva o tabela care tine numarul de credite ramase pentru fiecare IP. S-o interogam precum urmeaza :

SELECT count(ip) , remaining FROM credite GROUP BY remaining

Aceasta cerere tradusa-n limba romana uzuala inseamna "numara ip-urile pentru fiecare valoare a creditelor ramase". Rezultatul ?

234`630	0
87`681	1
10`644	2
1`970	3
136`554	4

Cam ce inseamna asta ? Ca din aproape jumatate de milion de ip-uri distincte (citi romani is pe Internet in total, apropo ?), 136 de mii au intrat o singura data, n-au mai revenit, ceea ce-ndeobste se numeste bounce. Dintre cei 334`925 care au revenit, 70% au revenit de minim sapte oriⁱ, 26% au revenit de minim sase ori, 3% au revenit de minim cinci ori si in fine 0.5% sau asa ceva au revenit de minim patru ori.

Sau cu alte cuvinte, tipul care ajunge pe Trilema are maximum 30% sanse sa plece furios si sa nu mai revina niciodata, si minimum 70% sase sa revina incintat, in general de un mare numar de ori (eu cred ca-i improbabil sa reuseasca sa treaca prin sapte articole intr-o singura zi, dat fiind ca aia ar insemna ca ordin de marime 7`000 de cuvinte din articol + 5-25`000 de cuvinte din comentarii, adica o carte).

Si-acum, ca tot am vorbit de vasta acoperire a Trilemei asupra Internetului de limba romana, sa vedem de-o curiozitate citi dintre astia 471`479 is din Romania.

SELECT count( ip ) FROM credite WHERE `remaining` < 5 AND ( `ip` LIKE '77.81.%' OR `ip` LIKE '78.95.%' OR `ip` LIKE '78.96.%' OR `ip` LIKE '78.97.%' OR `ip` LIKE '79.112.%' OR `ip` LIKE '79.113.%' OR `ip` LIKE '79.114.%' OR `ip` LIKE '79.115.%' OR `ip` LIKE '79.116.%' OR `ip` LIKE '79.117.%' OR `ip` LIKE '79.118.%' OR `ip` LIKE '79.119.%' OR `ip` LIKE '80.96.%' OR `ip` LIKE '80.97.%' OR `ip` LIKE '81.180.%' OR `ip` LIKE '81.181.%' OR `ip` LIKE '81.196.%' OR `ip` LIKE '82.76.%' OR `ip` LIKE '82.77.%' OR `ip` LIKE '82.78.%' OR `ip` LIKE '82.79.%' OR `ip` LIKE '85.120.%' OR `ip` LIKE '85.121.%' OR `ip` LIKE '85.122.%' OR `ip` LIKE '85.123.%' OR `ip` LIKE '85.186.%' OR `ip` LIKE '85.204.%' OR `ip` LIKE '86.34.%' OR `ip` LIKE '86.35.%' OR `ip` LIKE '86.55.%' OR `ip` LIKE '86.104.%' OR `ip` LIKE '86.105.%' OR `ip` LIKE '86.106.%' OR `ip` LIKE '86.107.%' OR `ip` LIKE '86.120.%' OR `ip` LIKE '86.121.%' OR `ip` LIKE '86.122.%' OR `ip` LIKE '86.123.%' OR `ip` LIKE '86.124.%' OR `ip` LIKE '86.125.%' OR `ip` LIKE '86.126.%' OR `ip` LIKE '86.127.%' OR `ip` LIKE '88.158.%' OR `ip` LIKE '89.32.%' OR `ip` LIKE '89.33.%' OR `ip` LIKE '89.34.%' OR `ip` LIKE '89.35.%' OR `ip` LIKE '89.36.%' OR `ip` LIKE '89.37.%' OR `ip` LIKE '89.38.%' OR `ip` LIKE '89.39.%' OR `ip` LIKE '89.40.%' OR `ip` LIKE '89.41.%' OR `ip` LIKE '89.42.%' OR `ip` LIKE '89.43.%' OR `ip` LIKE '89.44.%' OR `ip` LIKE '89.45.%' OR `ip` LIKE '89.46.%' OR `ip` LIKE '89.47.%' OR `ip` LIKE '89.114.%' OR `ip` LIKE '89.115.%' OR `ip` LIKE '89.120.%' OR `ip` LIKE '89.121.%' OR `ip` LIKE '89.122.%' OR `ip` LIKE '89.123.%' OR `ip` LIKE '89.136.%' OR `ip` LIKE '89.137.%' OR `ip` LIKE '92.80.%' OR `ip` LIKE '92.81.%' OR `ip` LIKE '92.82.%' OR `ip` LIKE '92.83.%' OR `ip` LIKE '92.84.%' OR `ip` LIKE '92.85.%' OR `ip` LIKE '92.86.%' OR `ip` LIKE '92.87.%' OR `ip` LIKE '92.114.%' OR `ip` LIKE '92.115.%' OR `ip` LIKE '93.112.%' OR `ip` LIKE '93.113.%' OR `ip` LIKE '93.114.%' OR `ip` LIKE '93.115.%' OR `ip` LIKE '93.116.%' OR `ip` LIKE '93.117.%' OR `ip` LIKE '93.118.%' OR `ip` LIKE '93.119.%' OR `ip` LIKE '93.168.%' OR `ip` LIKE '93.169.%' OR `ip` LIKE '94.48.%' OR `ip` LIKE '94.49.%' OR `ip` LIKE '94.52.%' OR `ip` LIKE '94.53.%' OR `ip` LIKE '94.60.%' OR `ip` LIKE '94.61.%' OR `ip` LIKE '94.62.%' OR `ip` LIKE '94.63.%' OR `ip` LIKE '94.176.%' OR `ip` LIKE '94.177.%' OR `ip` LIKE '95.76.%' OR `ip` LIKE '95.77.%' OR `ip` LIKE '95.162.%' OR `ip` LIKE '95.184.%' OR `ip` LIKE '95.185.%' OR `ip` LIKE '95.186.%' OR `ip` LIKE '95.187.%' OR `ip` LIKE '95.218.%' OR `ip` LIKE '95.219.%' OR `ip` LIKE '109.96.%' OR `ip` LIKE '109.97.%' OR `ip` LIKE '109.98.%' OR `ip` LIKE '109.99.%' OR `ip` LIKE '109.100.%' OR `ip` LIKE '109.101.%' OR `ip` LIKE '109.102.%' OR `ip` LIKE '109.103.%' OR `ip` LIKE '188.24.%' OR `ip` LIKE '188.25.%' OR `ip` LIKE '188.26.%' OR `ip` LIKE '188.27.%' OR `ip` LIKE '188.170.%' OR `ip` LIKE '188.172.%' OR `ip` LIKE '188.173.%' OR `ip` LIKE '188.208.%' OR `ip` LIKE '188.209.%' OR `ip` LIKE '188.210.%' OR `ip` LIKE '188.211.%' OR `ip` LIKE '188.212.%' OR `ip` LIKE '188.213.%' OR `ip` LIKE '188.214.%' OR `ip` LIKE '188.215.%' OR `ip` LIKE '188.240.%' OR `ip` LIKE '188.241.%' OR `ip` LIKE '193.230.%')

Zdravana magareata, este ? La 3271 de caractere cre' ca-i cel mai indelungat query pe care l-am trimis vre-odata catre mysql. Ip-urile le-am luat de la Nirsoft, precum vedeti n-am introdus decit clasele B, mai sunt o groaza de IP-uri acolo care apar cu cite jumatate, sfert, optime sau saisprezecime de clasa (de la 93.120.0.0 93.120.127.255 32768 11/02/2008 S.C. GVM SISTEM 2003 S.R.L. in jos). Rezultatele ?

359`462

Deci avem aici 1 × 1`048`576 + 6 × 524`288 + 7 × 262`144 + 14 × 131`072 + 12 × 65`536 = 8`650`752 de ip-uri, din care am vazut 359`462. Ne lipsesc 17 × 32`768 + 22 × 16`384 + 18 × 8`192 + 19 × 4`096 = 1`142`784, in care probabil ca om fi vazut, statistic procedind, inca 359`462 / 8`650`752 * 1`142`784, adica vreo 47`485.

Deci in total din cele 471`479 de IP-uri de-au cerut Trilema, 406`947 sau 86% sunt chiar din Romania. Restul, daca sunteti curiosi, sunt din Italia si Spania in vasta majoritate (ma intreb de ce oare, pe bune) si-apoi SUA, Canada, Germania, Australia scl etc.

Singura concluzie care-mi vine-n cap e-n limba engleza, si suna cam asa : a blog is a wonderful thing.

1. Pentru ca trebuie sa treci prin cele trei credite zilnice ca sa ajungi sa consumi cele patru credite cu care incepi, deci in principiu numarul minim de accesari pentru a ajunge cu creditele pe 0 este 7 (chestia se explica lamurit in articolul despre logica continutului platit). Pe de cealalta parte, daca citesti cite doua articole pe zi un an de zile (700+ articole) vei avea in continuare 4 credite, in virtutea acelorasi 3 gratuite pe zi, ceea ce inseamna ca am exagerat anterior considerindu-i pe toti aia 136 de mii ca bounce. Da' vorba ceea, sa exageram in detrimentul nostru, ca ne permitem. [↩]