Thank you.
Thanks to you, I solved it. Best Regards. -- YAMAZAKI Yoshihiro > -----Original Message----- > From: Hugh Williams [mailto:hwilli...@openlinksw.com] > Sent: Friday, February 12, 2016 7:43 PM > To: Yamazaki, Yoshihiro/山崎 嘉弘 > Cc: virtuoso-users@lists.sourceforge.net > Subject: Re: [Virtuoso-users] response time of the select query. > > 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/V > irtQueryOptDiagnostic > > 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 ------------------------------------------------------------------------------ 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
