sesame query execution time

Question

hi, i want to know the method which can help me to find out query execution time in sesame rdf framework.while i query with serql and sparql both.please help me.i need answer very urgently

Accepted Answer

2

Sesame's API does not expose this information directly to you AFAIK

With Java you can do the following to time operations:

long start = System.nanoTime();

//Perform your operation

long duration = System.nanoTime() - start;

You can then convert the duration in nanoseconds into seconds like so:

long seconds = TimeUnit.NANOSECONDS.toSeconds(duration);

link

answered 01 Apr '12, 16:36

Rob Vesse ♦
11.8k●6●15
accept rate: 28%

+1. Alternatively, you can look in the Sesame server logs to see how long any operation took to execute.

(01 Apr '12, 18:10) Jeen Broekstra ♦

hi, where should apply this java code in sesame long start = System.nanoTime();

//Perform your operation

long duration = System.nanoTime() - start; please tell me.

(02 Apr '12, 01:58) amita

@amita, Rob's solution is simply to get the system time (System.nanoTime()) before executing the query, and again after executing it. The difference will be the time it took to execute the query.

(02 Apr '12, 02:56) Jeen Broekstra ♦

1

Definitely a better answer than mine for this comparable question: http://answers.semanticweb.com/questions/15603/query-response-time-for-sparql. But seeing the confusion of the OP, I'd stick with the stopwatch ;-)

(02 Apr '12, 05:44) Gerrit V

this method of find the time in sesame doesn't help me because whenever i give the query to it server logs doesn't give me query execution time and System.nanoTime() also not working please tell me another way

(02 Jun '12, 02:16) amita

1

@amita: no.

(02 Jun '12, 03:55) Jeen Broekstra ♦

showing 5 of 6 show 1 more comments

Answer 2

You can use sesame console for this purpose:

$ /path/to/sesame/root/bin/console
> connect http://localhost:8080/openrdf-sesame .
> open my_repository .
my_repository > sparql
There should be the query
.

http://localhost:8080/openrdf-sesame should be replaced with the your sesame instance url.

After execution of these commands the console will show the result of the query and execution time (including the time for network interaction) in milliseconds. The same is true for serql.

Answer 3

This a java utility that would help you out.

Have tried it in one of my personal pet projects.

http://perf4j.codehaus.org/

StopWatch swatch=new LoggingStopWatch();

//Write all your querying logic in here]n

QueryExecution qexec=QueryExecutionFactory.sparqlService("http://dbpedia.org/sparql", query);

ResultSet rs=qexec.execSelect();

//this will print the time along with the passed message

swatch.stop("Results Obtained");

The reult would be something like this

start[1361269503870] time[1426] tag[Results Obtained]

Hope it helps :)

sesame query execution time

Follow this question

Upcoming Events

Related questions