Re: [Virtuoso-users] Query performance

Hi Sebastian, Indeed, I am only using the default indexes. Thanks a lot for the hint. I suppose I need indexes like gsop and gspo? OK, this is obviously BS. I think I need some private lessons in index design... anyway, I suppose something like SPOG POSG OPSG GSPO GPOS makes more sense? I w

Re: [Virtuoso-users] Query performance

On Tuesday 27 October 2009 20:12:34 Sebastian Trüg wrote: > Indeed, I am only using the default indexes. Thanks a lot for the hint. > I suppose I need indexes like gsop and gspo? OK, this is obviously BS. I think I need some private lessons in index design... anyway, I suppose something like SPO

Re: [Virtuoso-users] Query performance

Indeed, I am only using the default indexes. Thanks a lot for the hint. I suppose I need indexes like gsop and gspo? Cheers, Sebastian On Tuesday 27 October 2009 15:08:51 Ivan Mikhailov wrote: > Sebastian, > > What indexes are in use? It seems to me that only default indexes are > created, but p

Re: [Virtuoso-users] Virtuoso 6 problematic background activity

Hi James Can you please provide a copy of your Virtuoso Configuration file (virtuoso.ini) and Virtuoso log file (virtuoso.log) for review. Also, can you please clarifiy if: 1. This problem has only started occurring since your upgrade to the new 6.0.0 release as it seems unclear from you

Re: [Virtuoso-users] Query performance

Sebastian, What indexes are in use? It seems to me that only default indexes are created, but patterns with unspecified graph need, of course, two additional indexes. If the speed of the first query is suitable and you do not want to create additional indexes for some reason, consider select * w

[Virtuoso-users] Query performance

Just out of curiosity: why is there such a big difference in performance between the following 2 query variants (second one much slower than the first) select * where { ?r a nfo:FileDataObject . OPTIONAL { ?g ?r . } . FILTER(!BOUN

Re: [Virtuoso-users] Changing DAV permissions programatically

Aldo, Hi, I upload a file via WebDAV like so curl -u $CREDENTIALS -T "file.txt" http://server.com/DAV/home/dav/folder/ where /folder/ has readable by anyone. However, the uploaded file does not inherit permissions ( unless I am missing something ). Anwyay, as things stand today I need to ch

Re: [Virtuoso-users] I should warn you that SSD's lifetime under any database application can be smaller than expected

Hello Ceriel, It may be in firmware or in driver or not implemented at all. It is also possible that I provide obsolete hints, I haven't monitored SSD new for a year and one year is a very long time in this industry. Anyway, all you need is to make relatively frequent full backups and reserve som

[Virtuoso-users] Changing DAV permissions programatically

Hi, I upload a file via WebDAV like so curl -u $CREDENTIALS -T "file.txt" http://server.com/DAV/home/dav/folder/ where /folder/ has readable by anyone. However, the uploaded file does not inherit permissions ( unless I am missing something ). Anwyay, as things stand today I need to change its p