Report Page very slow

[axel]

HI

I Have ome problems with the /report1.php

it is very slow sometime only loading loading and many LOAD

anyone can help me ?

history table (history 21.991.549 InnoDB 2,0 GB)

[James Wells]

Greetings,

There is already a fix checked into CVS for this issue. Basically, what is happening is that the code, currently, is doing a full table scan via 'select count(*) from history' and immediately afterwards 'select count(*) from trends'. I checked in some code on Tuesday that cut the time down from roughly 30 minutes, against my 42 million rows in history, to roughly 4 seconds. Please note that if you pull the report1.php from CVS as it stands now, you will need the updated locale/* files as well as include/config.inc.php.

[axel]

Hi again (i uSe 1beta2)

I Try it but now i get this message

Error in query [select u.userid,u.alias,u.name,u.surname,u.lang,u.refresh from sessions s,users u where s.sessionid='2491844d4d3b9c264e3b124b2d0ac013' and s.userid=u.userid and ((s.lastaccess+u.autologout>1131445260) or (u.autologout=0))] [Unknown column 'u.refresh' in 'field list']
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/include/db.inc.php on line 145

Warning: Cannot modify header information - headers already sent by (output started at /var/www/include/db.inc.php:66) in /var/www/include/config.inc.php on line 982
Error in query [select u.userid,u.alias,u.name,u.surname,u.lang,u.refresh from users u where u.alias='guest'] [Unknown column 'u.refresh' in 'field list']
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/include/db.inc.php on line 145