November Statistik?

hui!! ich hab fast so a tolle ontopic-rate wie die Ece

| WONDERMIKE | 508 | 131 | 377 | 0.26 |

Zitat von .deRElict.

diemal mit sql-query:

Code:

mysql> create table temp_date as select count(*)/(round
((unix_timestamp(date_add(from_unixtime(dateline), interval 1 month))-
dateline)/86400)) as ppd, count(*)/(24*round((unix_timestamp
(date_add(from_unixtime(dateline), interval 1 month))-
dateline)/86400)) as pph, count(*)/(1440*round((unix_timestamp
(date_add(from_unixtime(dateline), interval 1 month))-
dateline)/86400)) as ppm, count(*) as total, from_unixtime((dateline),"%Y/%m") 
as month from post group by month order by month; select 
temp_date.*, sum(month >= from_unixtime(joindate,"%Y/%m")) as 
totalusers, avg(if(month >= from_unixtime(joindate,"%Y/%m") and 
unix_timestamp(birthday)>1,(unix_timestamp(CONCAT(REPLACE
(month,"/","-"),"-01")) - unix_timestamp(birthday))/
(86400*365.2425),NULL)) as avg_age,  sum(month = from_unixtime
(joindate,"%Y/%m")) as newusers, avg(if(month = from_unixtime
(joindate,"%Y/%m") and unix_timestamp(birthday)>1,(joindate - 
unix_timestamp(birthday))/(86400*365.2425),NULL)) as joinage, 
total/sum(month >= from_unixtime(joindate,"%Y/%m")) as ppu  from 
temp_date left join user on (month >= from_unixtime(joindate,"%Y/%
m")) group by month; drop table temp_date;

für den query alleine tät ich schon ne ganze weile sitzen...

Zitat

10.29 sec

jetzt weiss ich endlich woher die performance-einbrüche immer wieder kommen - diese stats

mal den alten thread ausgraben und die Decemberstats verlangen *g*

ot: watchout is da douglas adams da in diener sig ? wenn ja er 0wned

Zitat von 3N54

ot: watchout is da douglas adams da in diener sig ? wenn ja er 0wned

klaro, coole aussage oder? - vor allem weil ich fish ned ausstehn kann

titel vom 2ten isses afair
ich wollt eigentlich gods final message einbaun, hab die textstelle aber dann nimmer gefunden...

ps: der 2te teil vom hhgttg heisst _nicht_ "against tcpa"....