Hi Yoshihiro, What is the actual 7.2 version you are using ? Please provide the output of running the following against the binary:
virtuoso-t -?
If you are using a version less than the 7.2.2 (3215) release then you should
try setting the following in the “[Flags]” section of the virtuoso.ini
configuration file and restart the server:
[Flags]
enable_joins_only = 1
which prevent the possible occurrence of cartesian products when optimizing the
query, see:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtQueryOptDiagnostic
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
> On 12 Feb 2016, at 06:44, Yamazaki, Yoshihiro <[email protected]>
> wrote:
>
>
> 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
