screenconf.php too low

[exkg]

Hi,

In last version of 1.5.4 screenconf.php takes a long time to return some data. We are using Oracle10G and have ~1300 hosts and ~160 screens.

The code in screenconf.php:

===
$result=DBselect('SELECT s.screenid,s.name,s.hsize,s.vsize,(s.hsize*s.vsize ) as s_size '.
' FROM screens s '.
' WHERE '.DBin_node('s.screenid').
order_by('s.name,s_size','s.screenid'));
while($row=DBfetch($result)){

if(!screen_accessible($row["screenid"], PERM_READ_WRITE)) continue;

$table->AddRow(array(
new CLink($row["name"],"?config=0&form=update&screenid=".$row["screenid"],
'action'),
$row["hsize"]." x ".$row["vsize"],
new CLink(S_EDIT,"screenedit.php?screenid=".$row["screenid"])
));
}
===


To test environment we comment out this (check permissions):

===
if(!screen_accessible($row["screenid"], PERM_READ_WRITE)) continue;
===

Untill that we use only 'admin' user.


[]s,
Luciano