|
2003-03-26, 05:03
|
#1 |
Aug 2002
72·173 Posts |
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? |
|
|
|
2003-03-26, 05:12
|
#2 |
Aug 2002
847710 Posts |
(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)
);
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>
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>
|
|
|
|
|
2003-03-26, 07:11
|
#3 |
Sep 2002
12816 Posts |
ill see if i can shake out some times from my forum ( overclockers.com)
|
|
|
|
|
2003-03-26, 07:20
|
#4 |
Aug 2002
101011102 Posts |
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. |
|
|
|
|
2003-03-26, 08:02
|
#5 | ||
"Sander"
Oct 2002
52.345322,5.52471
29×41 Posts |
Quote:
Quote:
|
||
|
|
|
|
2003-03-26, 08:14
|
#6 |
Aug 2002
2×3×53 Posts |
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. |
|
|
|
|
2003-03-26, 08:51
|
#7 |
|
Aug 2002
72·173 Posts |
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... |
|
|
|
|
2003-03-26, 08:56
|
#8 | |
|
Aug 2002
72×173 Posts |
Quote:
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... |
|
|
|
|
|
2003-03-26, 18:51
|
#9 | |
Aug 2002
59 Posts |
Quote:
|
|
|
|
|
|
2003-03-26, 19:52
|
#10 | |
Jan 2003
North Carolina
2·3·41 Posts |
Quote:
I think a database like this would be invaluable. :D john |
|
|
|
|
|
2003-03-26, 21:30
|
#11 |
Aug 2002
111110012 Posts |
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 |
|
|
|
 |
| 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 |
