W3C home > Mailing lists > Public > public-sparql-dev@w3.org > July to September 2008

Re: TDB results for the Berlin SPARQL Benchmark

From: Chris Bizer <chris@bizer.de>
Date: Mon, 11 Aug 2008 13:18:43 +0200
Message-ID: <4C6684D8A82D442E9AD4209FC8B30B54@wrz03715>
To: "Seaborne, Andy" <andy.seaborne@hp.com>, <public-sparql-dev@w3.org>
Cc: <aschultz@inf.fu-berlin.de>

Hi Andy,

very promising results. Its great to see another store handling the 
100M dataset with a good performance.

Andreas will run another experiment with a slightly changed version of 
the benchmark on our machine in about 2 weeks. We will include TDB 
into this run so that we get directly comparable numbers for TDB.

If you have additional ideas for improving the benchmark before the 
second run, please let us know.
We already added two extra queries to the mix: A CONSTRUCT query and a 
query with unbound predicates.

Cheers

Chris


> This report is for TDB running the Berlin SPARQL Benchmark [1]
> TDB is a persistent subsystem for Jena.
>
> Thanks to Andreas Schultz who provided the configuration files and 
> updated tools necessary to run the benchmark on the downloaded 
> datasets.
>
> Date: 2008-08
>
> == Results
>
> = Load
> Using TDB's bulk loader: "tdbloader"
> Cold load into an empty database.
>
>          50K      250K        1M         5M      25M       100M
> Time/s   5.56     15.25     50.46     256.65   1258.07    5370.09
> TPS     9,020    16,427    19,824     19,483    19,872     18,621
>
> = Query
>            50K         250K         1M          5M         25M 
> 100M
> Query 1   0.007711  0.036216    0.066769    0.137431    0.442776 
> 1.463148
> Query 2   0.032370  0.046859    0.047317    0.047442    0.046882 
> 0.056338
> Query 3   0.008156  0.021385    0.058452    0.141895    0.410103 
> 1.429356
> Query 4   0.011558  0.019491    0.067215    0.220680    0.654449 
> 2.571348
> Query 5   0.069205  0.357140    0.973735    3.624503   21.729141 
> 84.927111
> Query 6   0.005759  0.043215    0.049023    0.062252    0.524726 
> 11.309403
> Query 7   0.037831  0.045588    0.197200    0.436487    0.711938 
> 0.771399
> Query 8   0.027343  0.060075    0.235520    0.480224    0.798117 
> 0.834888
> Query 9   0.006449  0.006994    0.009983    0.021610    0.032256 
> 0.041381
> Query 10  0.004890  0.014506    0.060580    0.103583    0.187552 
> 0.197450
>
> == Software
>
> Jena 2.5.6  <http://jena.sf.net/>
> ARQ 2.4     <http://jena.sf.net/ARQ>
> TDB 0.5     <http://jena.sf.net/TDB>
> Joseki 3.2  <http://www.joseki.org>
> Java        1.6.0_02
>            Sun Java HotSpot(TM) 64-Bit Server VM (build 
> 1.6.0_02-b05, mixed mode)
> OS: RHEL5
>
> TDB configuration:
>  None (TDB has no configuration options)
>
> == Hardware
>
> CPU: 4 CPU: AMD Opteron(tm) Processor 280 @1.8GHz
> Memory:   10Gbytes
>
> Note: this used non-local disk, using a shared disk array in a data 
> center.  This provides a more realistic set up of enterprise use. It 
> does make it difficult to draw deep conclusions when comparing with 
> different setups using local disk.
>
> Disk: HP EVA8000 running firmware xcsp-6100.
>
> The LUNs are configured as VRAID5, with read cache enabled and write 
> cache in write-back mode.  Two Qlogic fibre-channel ports (2GB 
> speed) connected to an MDS 9140 edge switch each, then an MDS9509 
> core switch and finally the EVA.
>
>    Andy
>
> [1] http://www4.wiwiss.fu-berlin.de/bizer/BerlinSPARQLBenchmark/
>
> --------------------------------------------
>  Hewlett-Packard Limited
>  Registered Office: Cain Road, Bracknell, Berks RG12 1HN
>  Registered No: 690597 England
> 
Received on Monday, 11 August 2008 11:19:51 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Monday, 11 August 2008 11:19:51 GMT