Hello,

I would like to have your opinion on the following:

I installed Virtuoso Enterprise on a Windows VM with:
8 cores
28 GB RAM
56 GB SSD

I attached virtuoso configuration file.

On virtuoso I have a local RDF Table with 8221 triples and a remote MS SQL 
Azure with 50 million records. A record is simply an id, param1 and param2, 
with (id and param1) as a composite primary key.
I have the following query:

Select ?id ?param1 ?param2 {
               Select ?id ?param1 ?param2 FROM 
<http://localhost:8890/sqldb50m#<http://localhost:8890/sqldb50m>>
 Where {
[] <http://localhost:8890/schemas/sqldb50m/id> ?id;
<http://localhost:8890/schemas/ sqldb50m 
/param1<http://localhost:8890/schemas/%20sqldb50m%20/param1>> ? param1;
<http://localhost:8890/schemas/ sqldb50m /param2 
<http://localhost:8890/schemas/%20sqldb50m%20/param2%20> > ? param2.
filter (?param1 < 5)
{
SELECT DISTINCT (strafter(str(?id1), "#") AS ?trimId) from 
<http://localhost:8890/BOC#<http://localhost:8890/BOC>>
WHERE
{
?server qt:hasId ?id1. //returns 42 ids
}
}
filter( ?trimId = ?id)
}
         };

The query is expected to return 1 million record result.
I initiated the query yesterday through iSQL, it is still running since, more 
than 12 hours. On the Windows VM, the task manager shows that Virtuoso consumes 
10 GB of RAM and less then 5% of CPU.
On the MS SQL monitoring tool, you can notice the load is constant using only 
10% of the CPU and 10% of the DTU.

Any recommendations to improve the performance?

Thank you
________________________________
This message was scanned by Exchange Online Protection Services.
________________________________

Attachment: virtuoso.ini
Description: virtuoso.ini

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most 
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to