Computer Chess Club Archives


Search

Terms

Messages

Subject: Re: SSDF list in database (grep) format

Author: Martin Andersen

Date: 03:53:45 10/24/03

Go up one level in this thread


On October 23, 2003 at 19:22:52, Dann Corbit wrote:

>ftp://cap.connx.com/chess-engines/new-approach/ssdf.mdb
>
>That way you can study by different things with simple SQL queries.  For
>instance, here I pulled up all the records that look like "Shredder":
>
>Rank	Engine	Hardware	Elo	plus	minus	Games Played	Won_Percentage	Opposition_Elo
>1	Shredder 7.04 UCI	256MB Athlon 1200 MHz	2812	28	-26	781	75%	2623
>3	Shredder 7.0	256MB Athlon 1200 MHz	2771	27	-25	801	70%	2623
>9	Shredder 6.0 Pad UCI	256MB Athlon 1200 MHz	2724	22	-22	1033	62%	2640
>10	Shredder 6.0	256MB Athlon 1200 MHz	2723	31	-30	547	62%	2634
>15	Shredder 7.0 UCI	128MB K6-2 450 MHz	2703	40	-39	316	58%	2648
>21	Shredder 5.32	256MB Athlon 1200 MHz	2660	26	-26	713	51%	2654
>31	Shredder 6.0 UCI	128MB K6-2 450 MHz	2617	43	-43	264	52%	2606
>35	Shredder 5.32	128MB K6-2 450 MHz	2606	25	-25	759	54%	2580
>39	Shredder 5.0	128MB K6-2 450 MHz	2588	19	-19	1347	52%	2575
>41	Shredder 4.0	128MB K6-2 450 MHz	2571	23	-22	986	58%	2511
>71	Shredder 3.0	64MB P200 MMX	2419	20	-20	1262	48%	2432
>75	Shredder 2.0	58MB P200 MMX	2404	19	-19	1314	44%	2444
>98	Shredder 1.0	Pentium 90 MHz	2284	59	-58	145	53%	2265

I used the advanced command 'grep' in order to pull out the following from
the txt file :
7 Hiarcs 9.0  256MB Athlon 1200 MHz       2746   51   -48   209   63%  2653
  17 Hiarcs 8.0  256MB Athlon 1200 MHz       2684   22   -22   996   53%  2663
  40 Hiarcs 8.0  128MB K6-2 450 MHz          2586   33   -34   440   42%  2646
  49 Hiarcs 7.32  128MB K6-2 450 MHz         2533   18   -19  1445   42%  2593
  51 Hiarcs 7.01  128MB K6-2 450 MHz         2521   30   -31   525   43%  2573
  63 Hiarcs 7.32  64MB P200 MMX              2472   21   -21  1134   52%  2459
  64 Hiarcs 7.0  64MB P200 MMX               2462   21   -21  1112   55%  2423
  70 Hiarcs 6.0  49MB P200 MMX               2421   24   -24   829   56%  2377
  85 Hiarcs 6.0 Pentium 90 MHz               2335   18   -18  1437   51%  2331
  87 Hiarcs 5.0 Pentium 90 MHz               2328   38   -36   363   59%  2263
  95 Hiarcs 4.0 Pentium 90 MHz               2293   25   -25   766   55%  2258
 101 Hiarcs 3.0 Pentium 90 MHz               2274   30   -30   545   56%  2229
 119 Hiarcs 3.0 486/50-66 MHz                2197   24   -24   865   50%  2194
 143 Hiarcs Master 2.0  486/33 MHz           2100   46   -46   229   51%  2090
 167 Hiarcs Master 1.0  486/33 MHz           1970   48   -48   214   48%  1986

Martin.




This page took 0 seconds to execute

Last modified: Thu, 15 Apr 21 08:11:13 -0700

Current Computer Chess Club Forums at Talkchess. This site by Sean Mintz.