[Virtuoso-users] response time of the select query.

[Yamazaki, Yoshihiro]

When executing a select query (as shown below) on Virtuoso 7.0 and 7.2,
the response time on each version was totally different.
While Virtuoso 7.0 just took less than a second,
Virtuoso 7.2 took more than 100 secs to retrieve the result.
Of course, the data registered in both Virtuoso environments is the same.
Below I provide some details.  If you need any additional information, please 
tell me.

- Only 4 records exist
- The select query retrieves just one record
- The where clause has 37 conditions
- The FILTER clause has 2 conditions

OS details:

Virtuoso is working on CentOS 6.4 (3GB system RAM) with the following buffer 
size (specified in the Virtuoso.ini file)
------
　MaxCheckpointRemap : 262144
　NumberOfBuffers    : 262144
　MaxDirtyBuffers    : 196608
------

I noticed that some new settings were added to Virtuoso 7.2's ini file.
Is there a possibility those new settings affect performance when executing the 
select clause?
Or, if there are other factors (that improve performance) that I'm missing, 
would you tell me please?

Thanks in advance for your help.



-----------------------------SELECT QUERY-------------------------------

sparql 
prefix odp: <http://xxxxxx/OpenDataLod/ns#> 
prefix dc: <http://purl.org/dc/elements/1.1/> 
prefix dct: <http://purl.org/dc/terms/> 
prefix vcard: <http://www.w3.org/2006/vcard/ns#> 
prefix schema: <http://schema.org/> 
prefix foaf: <http://xmlns.com/foaf/0.1/> 
select DISTINCT ?s
 
  from <http://xxxxxx/OpenDataLod/event>
  from <http://xxxxxx/OpenDataLod/promoter>
 where {
  ?s a odp:Event ;
    odp:event-type <http://xxxxxx/OpenDataLod/ev/type/1> ;
    odp:app-type ?appType ;
    dc:title ?title ;
    dc:description ?description ;
    odp:promoter ?promoter ;
    odp:event-category ?categoryURI ;
    odp:event-view-category ?iconCategory ;
    odp:event-area ?area ;
    odp:location ?location ;
    odp:age/odp:fromAge ?ageFrom ;
    odp:age/odp:toAge ?ageTo ;
    odp:fee ?fee ;
    odp:selectionType ?selection ;
    odp:applicationType ?method ;
    vcard:fn ?contact ;
    odp:parentsRequirement ?parent ;
    odp:region-limited ?region ;
    dct:created ?created ;
    dct:modified ?modified ;
    odp:createUserid ?createUser ;
    odp:updateUserid ?updateUser ;
    odp:deleteFlag 0 ;
    odp:locality ?locality ;
    odp:statusFlag 2 ;
    odp:holdDate ?holdDate .
      ?holdDate schema:startDate ?sdate ;
                schema:endDate ?edate .
      ?promoter odp:group ?group .
    OPTIONAL {
      ?s schema:url ?url .
    }
    OPTIONAL {
      ?s odp:location-name ?locationName .
    }
    OPTIONAL {
      ?s odp:targetPerson ?targetPerson .
    }
    OPTIONAL {
      ?s odp:memberQuota ?member .
    }
    OPTIONAL {
      ?s odp:period ?period .
    }
    OPTIONAL {
      ?s vcard:tel ?telSubsc .
    }
    OPTIONAL {
      ?s vcard:fax ?faxSubsc .
    }
    OPTIONAL {
      ?s vcard:email ?emailSubsc .
    }
    OPTIONAL {
      ?s vcard:adr ?adrSubsc .
    }
    OPTIONAL {
      ?s odp:additional-info ?addInfo .
    }
    OPTIONAL {
      ?s foaf:image ?image .
    }
    OPTIONAL {
      ?s odp:holdDisplayDate ?displayDate .
    }
    FILTER (?appType = iri(??))
    FILTER (?locality = "12345")
}
 ORDER BY asc(?created)

--------------------------------------------------------------------------


------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users