mersenneforum.org  

Go Back   mersenneforum.org > Great Internet Mersenne Prime Search > Hardware

Reply
 
Thread Tools
Old 2003-03-26, 05:03   #1
Xyzzy
 
Xyzzy's Avatar
 
"Mike"
Aug 2002

2·3·1,301 Posts
Default Volunteers needed!

I think it is time we all worked together and built a decent benchmark system... One that can do custom queries and possibly graph results and crap like that...

You all know I have less than a clue, but here is what I have so far...

http://www.mersenneforum.org/benchmarks/

You can view existing benchmarks in the database, and you can add new ones to it via the web...

Obviously, this is a test, not a real benchmark system... It is just something I threw together to see how hard it would be... I will post my 1337 source code shortly...

So who will take that big step towards infamy and hop on board with me?
Xyzzy is offline   Reply With Quote
Old 2003-03-26, 05:12   #2
Xyzzy
 
Xyzzy's Avatar
 
"Mike"
Aug 2002

2×3×1,301 Posts
Default

(I'm sure my source code will be a constant source of laughter to you all, but you gotta start somewhere, right?)

Here is how I set up the database...

Code:
drop table if exists benchie;

create table benchie
        (
        a char(40),
        b decimal(6,2),
        c decimal(7,3),
        d decimal(7,3),
        e decimal(7,3),
        f decimal(7,3),
        g decimal(7,3),
        h decimal(7,3),
        i decimal(7,3),
        j decimal(7,3),
        k decimal(7,3),
        l decimal(7,3),
        m decimal(7,3),
        n decimal(7,3)
        );
This is how the index.php page is written...

Code:
<html>
        <head>
                <title>mersenneforum.org view benchmark</title>
        </head>
        <body>
                <h1>Data from benchmark database</h1>
                <?
                        mysql_connect("db40.pair.com", "xyzzy_36_r", "xxxxxxxx");
                        $query = "SELECT a, b, c, d, e, f, g, h, i, j, k, l, m, n FROM benchie";
                        $result = mysql_db_query("xyzzy_benchmarks", $query);
                        if ($result) {
                                echo "Found these entries in the database:<code>";
                                while ($r = mysql_fetch_array($result)) {
                                        $a = $r["a"];
                                        $b = $r["b"];
                                        $c = $r["c"];
                                        $d = $r["d"];
                                        $e = $r["e"];
                                        $f = $r["f"];
                                        $g = $r["g"];
                                        $h = $r["h"];
                                        $i = $r["i"];
                                        $j = $r["j"];
                                        $k = $r["k"];
                                        $l = $r["l"];
                                        $m = $r["m"];
                                        $n = $r["n"];
                                        echo "$a";
                                        echo "CPU speed: $b MHz";
                                        echo "Best time for 320K FFT length: $c ms.";
                                        echo "Best time for 384K FFT length: $d ms.";
                                        echo "Best time for 448K FFT length: $e ms.";
                                        echo "Best time for 512K FFT length: $f ms.";
                                        echo "Best time for 640K FFT length: $g ms.";
                                        echo "Best time for 768K FFT length: $h ms.";
                                        echo "Best time for 896K FFT length: $i ms.";
                                        echo "Best time for 1024K FFT length: $j ms.";
                                        echo "Best time for 1280K FFT length: $k ms.";
                                        echo "Best time for 1536K FFT length: $l ms.";
                                        echo "Best time for 1792K FFT length: $m ms.";
                                        echo "Best time for 2048K FFT length: $n ms.";
                                }
                                echo "</code>";
                        }
                        else {
                                echo "No data.";
                        }
                        mysql_free_result($result);
                ?>
                <p>
                        <a href="add.php">Add new entry</a>
                </p>
        </body>
</html>
And this page adds new stuff...

Code:
<html>
        <head>
                <title>mersenneforum.org add benchmark</title>
        </head>
        <body>
                <?
                        if (isset($a)) {
                                mysql_connect("db40.pair.com", "xyzzy_36_w", "xxxxxxxx");
                                $query = "INSERT INTO benchie VALUES ('$a', '$b', '$c', '$d', '$e', '$f', '$g', '$h', '$i', '$j', '$k', '$l', '$m', '$n')";
                                $result = mysql_db_query("xyzzy_benchmarks", $query);
                                if ($result) {
                                        echo "<p>Your benchmark was added to the database</p>";
                                }
                        }
                ?>
                <h1>Add an entry</h1>
                <form>
                        CPU STRING: <input type=text name='a'>
                        CPU SPEED: <input type=text name='b'>
                        320K FFT: <input type=text name='c'>
                        384K FFT: <input type=text name='d'>
                        448K FFT: <input type=text name='e'>
                        512K FFT: <input type=text name='f'>
                        640K FFT: <input type=text name='g'>
                        768K FFT: <input type=text name='h'>
                        896K FFT: <input type=text name='i'>
                        1024K FFT: <input type=text name='j'>
                        1280K FFT: <input type=text name='k'>
                        1536K FFT: <input type=text name='l'>
                        1792K FFT: <input type=text name='m'>
                        2048K FFT: <input type=text name='n'>
                        <input type=submit>
                </form>
                <p>
                        <a href="index.php">Back to index</a>
                </p>
        </body>
</html>
Xyzzy is offline   Reply With Quote
Old 2003-03-26, 07:11   #3
crash893
 
crash893's Avatar
 
Sep 2002

4508 Posts
Default

ill see if i can shake out some times from my forum ( overclockers.com)
crash893 is offline   Reply With Quote
Old 2003-03-26, 07:20   #4
xtreme2k
 
xtreme2k's Avatar
 
Aug 2002

2568 Posts
Default

Xyzzy

Only that you forgot to mention these must be results from the newer 23.1+ versions.

By the way I think the original table layout from the older benchmarks we have is much better than what you got there.
xtreme2k is offline   Reply With Quote
Old 2003-03-26, 08:02   #5
smh
 
smh's Avatar
 
"Sander"
Oct 2002
52.345322,5.52471

29·41 Posts
Default

Quote:
Originally Posted by xtreme2k
Only that you forgot to mention these must be results from the newer 23.1+ versions.
I think the version should be included in the database, that way we can compare speed improvements for various version.

Quote:
By the way I think the original table layout from the older benchmarks we have is much better than what you got there.
Yes it is, but someone should be able to write a webpage that reads the data from the database and displays it the way you want.
smh is offline   Reply With Quote
Old 2003-03-26, 08:14   #6
outlnder
 
outlnder's Avatar
 
Aug 2002

2×3×53 Posts
Default

Instead of asking us to file in each line, how about just letting in a big chunk, so we can copy and paste.

This would also allow us to add things like DDR speed or RDRAM speed, motherboard, chipset maybe even CPU cooling.

A great benchmark page allows for most all possible variables. This allows the cruncher to see which chipset or memory will produce the best and fastest results.

Via chipset versus Sis versus Intel versus NVidia, etc.
outlnder is offline   Reply With Quote
Old 2003-03-26, 08:51   #7
Xyzzy
 
Xyzzy's Avatar
 
"Mike"
Aug 2002

171768 Posts
Default

I suppose the first thing we have to decide is which data we want to include... I didn't list most of the stuff we want because that database I linked to above is just a sample...

I agree that the version number is important...

I also think that once the data is in the database, people can make pages to pull that data out in special ways... Since we are coding this database out in the open, the database labels will be known to all, and I will allow read-only access to the database to anyone...

FYI, here are the login parameters for read-only access...

Database server = "db40.pair.com"
Database = "xyzzy_benchmarks"
Username = "xyzzy_36_r"
Password = "5qJ8q7W2"

The reason we can't just allow a big text field for people to cut and paste their results in is because then we cannot manipulate that data on a by-item basis...

I do think a large text comments field might be a good idea...
Xyzzy is offline   Reply With Quote
Old 2003-03-26, 08:56   #8
Xyzzy
 
Xyzzy's Avatar
 
"Mike"
Aug 2002

2·3·1,301 Posts
Default

Quote:
Originally Posted by xtreme2k
Xyzzy
By the way I think the original table layout from the older benchmarks we have is much better than what you got there.
Think of this system like a two step process...

In the old days we used Wordstar... In step one you added the text and in step two you formatted it...

For this project, step one is simply getting the data into the database... After we do that the next step will be to format it so it is pretty...

The nice thing about doing this in two steps is it makes things a lot simpler...

If we can decide on a standard "record" for the database, we can actually go live within just a few days...

I'm hoping there are database experts out there who can help us with things like reliability, error checking the input and crap like that...
Xyzzy is offline   Reply With Quote
Old 2003-03-26, 18:51   #9
NookieN
 
NookieN's Avatar
 
Aug 2002

3·19 Posts
Default

Quote:
Originally Posted by Xyzzy
The reason we can't just allow a big text field for people to cut and paste their results in is because then we cannot manipulate that data on a by-item basis...
A simple Perl script would take care of that for you. Just have people paste their scores into the large test field and the script can parse it out for the database.
NookieN is offline   Reply With Quote
Old 2003-03-26, 19:52   #10
nomadicus
 
nomadicus's Avatar
 
Jan 2003
North Carolina

24610 Posts
Default

Quote:
Originally Posted by Xyzzy
For this project, step one is simply getting the data into the database... After we do that the next step will be to format it so it is pretty...
Data I'd like to see in the database would include FSB, memory type, etc. It's been my experience a single stick of generic memory can slow down prime95 by 18%. So . . . I'd like access to individual records to sort out what my next system to build should be like.

I think a database like this would be invaluable. :D
john
nomadicus is offline   Reply With Quote
Old 2003-03-26, 21:30   #11
pakaran
 
pakaran's Avatar
 
Aug 2002

3·83 Posts
Default

By the way, for those who aren't aware, I've handed the benchmark task over to Xyzzy. Not that it will make any difference - I think people will still be emailing benchmarks to George, but I thought I should let folks know what's going on.

Nathan
pakaran is offline   Reply With Quote
Reply

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Call for volunteers: RSA896 jasonp Operation Kibibit 134 2013-09-03 22:08
Volunteers needed axn GPU Computing 28 2012-05-28 12:05
call for volunteers: RSA768 polynomial selection jasonp Operation Kibibit 200 2011-11-05 21:31
V24.12 QA help needed Prime95 Software 5 2005-06-17 15:54
We need two volunteers... Xyzzy PrimeNet 8 2003-02-27 02:26

All times are UTC. The time now is 06:00.

Wed Nov 25 06:00:53 UTC 2020 up 76 days, 3:11, 4 users, load averages: 1.69, 1.82, 1.69

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.

This forum has received and complied with 0 (zero) government requests for information.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.
A copy of the license is included in the FAQ.