[Firebird-test] Re: [Firebird-devel] TPC-R load / run test

[Mark O'D. <mar...@lu...>]

I write to you under difficult circumstance, my machine is slugishly
slow, there is next to no space left in my /tmp directory, and the
characters are slow to appear on the screen as I type.  What does this mean?

Well it means I've been able to run Tord's TPC-R benchmarks (mind you I
should have read the instructions I didn't have 2gig spare on my root
partition).  fortunately it came with a scale option so I could get by
with somewhat less.

I get a few errors, but basically it's there, next week (moving on from
dejaTCS testing, and TCS testing of 1.0.0. Beta2 linux builds) I will be
back to looking at the testing the >2Gbyte databases for fb linux
edition.  I have a (spare?) dual 1ghz machine there with a 40gig disk
space that I can use to test them, and Im sure these test are something
I can use...

Thanks Tord for giving me the ability to trash my linux box :-).

Cheers

Mark



Tord Hammer wrote:

 >Hi,
 >
 >I have tried to get the TPC-R benchmark running with FireBird.
 >
 >You can download the linux-version from:
 >http://www.hammer-software.de/fb/tpcr-firebird.tar.gz
 >


 >
 >The original sourcecode can be found at
 >http://www.tpc.org/tpcr/default.asp#spec
 >
 >If you want only the original queries than look at
 >http://www.hammer-software.de/fb/tpcr-queries.tar.gz
 >
 >
 >After extracting of tpcr-firebird.tar.gz, you can generate
 >the tpcr.gdb with the command:
 >    ./maketpc.sh
 >
 >Useful parameters are -h for help, -p for path-prefix (if you
 >dont have enough room at /tmp) and -s for scale factor.
 >
 >The queries can be executed with
 >    ./runtpc.sh
 >
 >Now my results:
 >
 >with scale 0.1 (results in a 150 MB database), the queries need
 >about 5-10 seconds each, with 100-200 seconds for query 20 and 21.
 >
 >for scale 1.0 and the parameter-values from tpcr_current.pdf
 >I could check the returned rows as well:
 >
 >maketpc run about two hours.
 >
 >query  | execution time (seconds) | correct result
 >-------+--------------------------+---------------
 >   1   |          700             |       yes
 >   2   |          250             |       yes
 >   3   |          700             |        no
 >   4   |          300             |       yes
 >   5   |          300             |       yes
 >   6   |          300             |       yes
 >   7   |          700             |       yes
 >   8   |          500             |       yes
 >   9   |         6500             |       yes
 >  10   |          400             |        no
 >-------+--------------------------+---------------
 >  11   |          150             |       yes
 >  12   |          350             |        no
 >  13   |         1800             |        no
 >  14   |          200             |       yes
 >  15   |          570             |       yes
 >  16   |           70             |       yes
 >  17   |          150             |        no
 >  18   |          350             |       yes
 >  19   |          700             |       yes
 >  20   |       still running      |       n/a
 >-------+--------------------------+---------------
 >  21   |       still running      |       n/a
 >  22   |       still running      |       n/a
 >
 >
 >The system is linux 2.2.16 (from SuSE 7.0)
 >AthlonB 1200, 256 GB RAM
 >one big 20 GB ext2-partition at the second half of a
 >40 GB hard disk.
 >FireBird Classic Build 347
 >Buffers = 10000
 >
 >
 >Comments, better queries or better indexes welcome.
 >
 >
 >Tord
 >
 >
 >
 >
 >_______________________________________________
 >Firebird-devel mailing list
 >Fir...@li...
 >http://lists.sourceforge.net/lists/listinfo/firebird-devel
 >


-- 
Your database needs YOU!
http://firebird.sourceforge.net
GPL: free software today - and still free tomorrow