Hi Bart,
You still have not provided the "profile" for each query. You can do this by
running "SET PROFILE ON/OFF" as did for the explain plans ...
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 23 Apr 2014, at 11:55, Bart Vandewoestyne <bart.vandewoest...@telenet.be>
wrote:
> On 2014-04-18 19:19, Hugh Williams wrote:
>> Hi Bart,
>>
>> The explain command whilst useful only provide the compile into,, where
>> the new v7 "profile(0" function provided both compile and execute info.
>> and it was I requested ie
>>
>> profile('select * from table where field = ''text''');
>>
>> The plans will be analysed by development ...
>>
>> Best Regards
>> Hugh Williams
>
> Hello list,
>
> I'm still continuing to try to improve the execution time of two of my
> queries. My current timings can be found in the folder
>
> https://www.dropbox.com/sh/hm0nj8q0j6pnx1k/cEcfYD6h-P
>
> Still, query 1 and 4 take about 60 to 70 seconds, which still too much
> and I still believe that these can be improved by tweaking my
> virtuoso.ini or other stuff.
>
> All necessary information (os, virtuoso version, profiling info, query
> explains, virtuoso.ini file...) can be found in the same folder. If
> other info is necessary, please let me know.
>
> What else could I try to improve these two slowest queries?
>
> Regards,
> Bart
>
> ------------------------------------------------------------------------------
> Start Your Social Network Today - Download eXo Platform
> Build your Enterprise Intranet with eXo Platform Software
> Java Based Open Source Intranet - Social, Extensible, Cloud Ready
> Get Started Now And Turn Your Intranet Into A Collaboration Platform
> http://p.sf.net/sfu/ExoPlatform
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
