Hi Marco,
Can you please confirm the Virtuoso version and build date being used
which can be obtained from the left from of the Virtuoso Conductor
Admin UI or by running "virtuoso -?" on the server executable. Also,
please confirm whether you are using the open source or commercial
version of Virtuoso.
I gather you are working on the SWAN project and thus I presume query
names given below are related to some form of test module used in
this project ? Can sample queries be provided for each such that they
can be analyzed. Providing the output of the explain() function which
provides details of the query execution plans within the Virtuoso
Server would also be useful for analysis. Details on the use of the
Virtuoso explain() function can be obtained from:
http://docs.openlinksw.com/virtuoso/fn_explain.html#(NULL)
Please do confirm your Virtuoso version details first though such
that we can ensure you are running the latest 5.0.8 builds available ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 12 Sep 2008, at 16:10, Marco Ocana wrote:
Hi,
I have been doing some preliminary testing of Virtuoso and ran into
an very odd behavior.
I loaded our test data set of 500K triples using the rdf_sink
mechanism into one graph.
I also updated the RDF_QUAD table definition to coincide with the
performance tuning tips described in http://docs.openlinksw.com/
virtuoso/rdfperformancetuning.html .
Below is a table with the timing results of different access methods.
As you can see, using the SPARQL end point is by far the fasted
access method.
Does this data match your performance expectations for the
different access methods or is there a particular things to watch
out for using the JDBC interface?
Thanks,
Marco
Query
Rows
ISQL (ms)
JDBC (ms)
SPARQL HTTP Endpoint
hypothesesTriplesWithoutAuthors
2942
1409
6615
93
hypothesesTriplesWithOptionalAuthors
49317
46644
172072
4349
hypothesesTriplesWithUnionAuthors
4144
2267
9463
153
hypothesesTriplesWithTitleFilter
399
175
945
26
hypothesesTriplesWithTitleFiterAndUnionAuthors
11563
5525
23123
428
marchesisHypothesisWithUnionAuthors
52
49
154
12
marchesiHypothesisContainedResearchStatements
787
379
1970
26
----------------------------------------------------------------------
---
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK & win
great prizes
Grand prize is a trip for two to an Open Source event anywhere in
the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
