sort order in hosts_user.php
20 Jul 2005 14:22:05 UTC
Topic 189571
(moderation:
Could we - maybe as an option - get the old sort order of the hosts back?
The additional "last contact" column, sorted by time, has been very useful for watching over hosts that run unattended.
I wish all projects had this column.
sort order in hosts_user.php
)
Sorry -- fixed -- I overwrote this change by accident. I'll make this change in BOINC CVS so other projects get it too.
Bruce
Director, Einstein@Home
I too have found that sorted
)
I too have found that sorted last contact column to be very useful where large numbers of hosts are involved. Up until recently it was ordered with "oldest first" but today it seems to be "newest first". The advantage to me of the previous order was being able to see which hosts were not performing without having to scroll to the bottom of a long list. Now I need to scroll to bottom. However, in some cases I would find the ability to set either order to be useful.
No big deal but perhaps it might be possible for the user to click a link/button to set the order. There is something similar when viewing the top participants. You can click the heading to get either RAC order or TC order - very nice. With the hosts page, I can imagine it might also be useful to arrange the hosts in a variety of orders such as HostID, reverse HostID, RAC, reverse RAC, etc. This should only be considered if it is trivial to implement.
I will however enjoy the last contact column propagating to other projects. I've missed it in Seti for a while now.
Cheers,
Gary.
@Bruce: Thanks :-) It's
)
@Bruce: Thanks :-)
It's very useful to see if one host fails to contact for a while and it helps to know when a change in the preferences has been propagated to all hosts.
@Gary : Currently the sort order depends on an SQL SELECT, changing the sort order "on the fly" would always lead to additional database queries.
As the host count usually isn't such a large number, it should be possible to fetch them into a PHP array, sort them and _then_ fill them into the rows.
This would lead to sligtly more CPU and memory load but I think the bottleneck is more the database rather than memory or CPU. This load could even be reduced a little by selecting only the required columns instead of using "select * from"
I modified hosts_user.php so
)
I modified hosts_user.php so that one can sort on any of the columns.
Director, Einstein@Home