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 <yoshi_yamaz...@jp.fujitsu.com> > 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 > Virtuoso-users@lists.sourceforge.net > 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 Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users