database system

Message boards : Number crunching : database system
Message board moderation

To post messages, you must log in.

AuthorMessage
Profile Dr. Leland Gilsen

Send message
Joined: 8 Dec 99
Posts: 4
Credit: 7,834,254
RAC: 4
United States
Message 42556 - Posted: 3 Nov 2004, 18:54:02 UTC

With all of the programmers involved with seti, why can't someone set up a simple system to find a specific person in the summary stats? If I am, 670th, for example, I have to look through 33+ pages at 20 per page, to find myself. Why can't I just jump to a specified person or a specified range of averages or totals?

What would be that hard. Most databases do this.
ID: 42556 · Report as offensive
Bill Barto

Send message
Joined: 28 Jun 99
Posts: 864
Credit: 58,712,313
RAC: 91
United States
Message 42557 - Posted: 3 Nov 2004, 18:59:59 UTC

I use this site to check my place rank:

http://www.setisynergy.com/stats/

After you get the search results click on your name and you will get all kinds of good info.
ID: 42557 · Report as offensive
Profile Stephen Balch
Avatar

Send message
Joined: 20 Apr 00
Posts: 141
Credit: 13,912
RAC: 0
United States
Message 42564 - Posted: 3 Nov 2004, 19:38:25 UTC

It's not that big a deal to jump as many records into the, for instance, "Top participants" display as you would like. The URL for the second page of the "Top participant" display is:

http://setiweb.ssl.berkeley.edu/top_users.php?sort_by=expavg_credit&offset=20

Just change the offset value from 20 to, in your case, 660. Hit the Enter key, and, bingo, all the records from 661 to 680 are displayed. You can page forward in the list or backward using the "Previous 20 | Next 20" links at the bottom if the page. Using this approach, no additional programming is necesary, it's already built in to the system.

The "Top computers" display is:

http://setiweb.ssl.berkeley.edu/top_hosts.php?sort_by=expavg_credit&offset=XX

THe "Top teams" display is:

http://setiweb.ssl.berkeley.edu/top_teams.php?sort_by=expavg_credit&offset=XX

Just change the XX to some number just shy of the point in the list at which you want to look.

Cheers,

Stephen
<P>"I want to go dancing on the moon, I want to frolic in zero gravity!....", and now, I might be able to go someday! Thanks, SpaceShipOne and crew!<BR><a><img src="http://69.93.59.107/stats/banner.php?cpid=26cbd89db7fb85cbfe580729d76705c1"></a>
ID: 42564 · Report as offensive

Message boards : Number crunching : database system


 
©2024 University of California
 
SETI@home and Astropulse are funded by grants from the National Science Foundation, NASA, and donations from SETI@home volunteers. AstroPulse is funded in part by the NSF through grant AST-0307956.