Re: Jena Performance Issue

[Andy Seaborne]

Hi Sushanth,

It's hard to say anything definitive because
What is the storage?
Is this running Fuseki or using Jena embedded within an application?

How much data is there?
How man query results?


On 29/01/2021 12:47, Sushanth Vaddaram wrote:
Hi All,

Whenever I run JMETER script with 10 users , it increases my CPU utilization to 
97% .

Is that one core at alost 100% or all cores?


Is there any way I can find out the issue which is causing this.

I'm unclear here - if jmeter is running tests in a repeated loop, then 
CPU of at least one core will be max'ed out.

Is there anything I can do to fix the issue.

PREFIX dip:<http://sce.ccs.utc.com/dip/reference-ontology#>
PREFIX map-onto:<http://sce.ccs.utc.com/dip/mapping-ontology#>
PREFIX auth:<http://sce.ccs.utc.com/dip/semantics/authorization#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>


This query could be simplified. I don't know your dataa


1/ Pull out the common pattern and evaluiate it once.

WHERE {
  ?datapointURI  rdf:type   dip:DataPoint  .
  ?datapointPROVIDER  dip:provides_info_object   ?datapointURI .
  ?datapointPROVIDER  dip:in_system  <http://dip.bis.utc.com/7#bacnet_7>
  .
  { ?datapointURI  rdf:type   ?datapointTYPE . }
  UNION
  { ?datapointURI  rdfs:label   ?datapointLABEL . }
  UNION
  { ?datapointURI  dip:data_source_url   ?datapointDATAMOD . }
  ...

and maybe (data and use case depending ) - it changes the query but 
maybe this is what you are trying to do:

WHERE {
  ?datapointURI  rdf:type   dip:DataPoint  .
  ?datapointPROVIDER  dip:provides_info_object   ?datapointURI .
  ?datapointPROVIDER  dip:in_system  <http://dip.bis.utc.com/7#bacnet_7>
  .
  ## Do you need this?
  ## OPTIONAL { ?datapointURI  rdf:type   ?datapointTYPE . }
  OPTIONAL { ?datapointURI  rdfs:label   ?datapointLABEL . }

2/ see below

SELECT DISTINCT
   ?datapointURI  ?datapointTYPE  ?datapointLABEL  ?datapointSYSTEM  
?datapointPROVIDER  ?datapointDATAMOD  ?datapointABSTPROP
WHERE
{
  {
  ?datapointURI  rdf:type   dip:DataPoint  .
  ?datapointPROVIDER  dip:provides_info_object   ?datapointURI .
  ?datapointPROVIDER  dip:in_system  <http://dip.bis.utc.com/7#bacnet_7> .
  ?datapointURI  rdf:type   ?datapointTYPE .
  }
        UNION
  {
  ?datapointURI  rdf:type   dip:DataPoint  .
  ?datapointPROVIDER  dip:provides_info_object   ?datapointURI .
  ?datapointPROVIDER  dip:in_system  <http://dip.bis.utc.com/7#bacnet_7> .
  ?datapointURI  rdfs:label   ?datapointLABEL .
  }
        UNION
  {
  ?datapointURI  rdf:type   dip:DataPoint  .
  ?datapointPROVIDER  dip:provides_info_object   ?datapointURI .
  ?datapointPROVIDER  dip:in_system  <http://dip.bis.utc.com/7#bacnet_7> .
  ?datapointURI  dip:data_source_url   ?datapointDATAMOD .
  }
        UNION
  {
  ?datapointURI  rdf:type   dip:DataPoint  .
  ?datapointPROVIDER  dip:provides_info_object   ?datapointURI .
  ?datapointPROVIDER  dip:in_system  <http://dip.bis.utc.com/7#bacnet_7> .
  ?datapointPROVIDER  dip:provides_info_object   ?datapointURI .
  ?datapointPROVIDER  dip:in_system   ?datapointSYSTEM .
  }
        UNION
  {
  ?datapointURI  rdf:type   dip:DataPoint  .
  ?datapointPROVIDER  dip:provides_info_object   ?datapointURI .
  ?datapointPROVIDER  dip:in_system  <http://dip.bis.utc.com/7#bacnet_7> .
  ?datapointPROVIDER  dip:provides_info_object   ?datapointURI .
  }
        UNION
  {
  ?datapointURI  rdf:type   dip:DataPoint  .
  ?datapointPROVIDER  dip:provides_info_object   ?datapointURI .
  ?datapointPROVIDER  dip:in_system  <http://dip.bis.utc.com/7#bacnet_7> .
  ?datapointURI  dip:abstracts   ?datapointABSTPROP .
  }
{




SELECT DISTINCT
   ?datapointURI
WHERE
{
  {
  ?zoneURI  dip:covers  
<http://test.dip.ales/spacetest#03d78792bb3eb3086b9e4135> .
  ?zoneURI  dip:has_scene_property   ?zonePROP .
  ?datapointURI  dip:abstracts   ?zonePROP .
  ?datapointURI  rdf:type   dip:DataPoint  .
  }
        UNION
  {
<http://test.dip.ales/spacetest#03d78792bb3eb3086b9e4135>  
dip:spatial_containment   ?deviceURI .
  ?deviceURI  dip:provides_info_object   ?datapointURI .
  ?datapointURI  rdf:type   dip:DataPoint  .
  }
        UNION

This shares a common block with the pattern earlier.

  {
  ?datapointURI  rdf:type   dip:DataPoint  .
  ?datapointPROVIDER  dip:provides_info_object   ?datapointURI .
  ?datapointPROVIDER  dip:in_system  <http://dip.bis.utc.com/7#bacnet_7> .
<http://test.dip.ales/spacetest#03d78792bb3eb3086b9e4135>  
dip:contains_hardware / dip:contains_hardware_device   ?deviceURI .
  ?deviceURI  dip:provides_info_object   ?datapointURI .
  ?datapointURI  rdf:type   dip:DataPoint  .
  }
}

}
}