Hi Lorena, You can also use the Virtuoso "status()" function to check the current status of the database as detailed at:
http://docs.openlinksw.com/virtuoso/dbadm.html#DBSTAT
A SPARQL select query counting the number of triples is always a good way to
check if the load is still in progress ie select count(*) where {?s ?p ?o}
Note, do check with buffers allocated and used from the status output ie "7000
buffers, 6987 used" for example to ensure they are not all being used as this
will result in data having to be written to disk which will slow performance.
So do check the Virtuoso performance tuning guide to ensure the server is
configured to make of the resources available on your machine, as detailed at:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFPerformanceTuning
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 29 Jan 2013, at 00:20, lorena <[email protected]> wrote:
> This is the result of top, so it seems to be still working :)
>
> top - 18:38:00 up 2 days, 1:34, 2 users, load average: 1.96, 1.92, 1.87
> Tasks: 105 total, 1 running, 104 sleeping, 0 stopped, 0 zombie
> Cpu(s): 15.6%us, 84.4%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
> Mem: 3613868k total, 3518444k used, 95424k free, 83060k buffers
> Swap: 0k total, 0k used, 0k free, 2955920k cached
>
> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
> 4352 root 20 0 227m 207m 9716 S 99.7 5.9 213:36.36 virtuoso-t
>
>
> On Mon, Jan 28, 2013 at 10:16 PM, lorena <[email protected]> wrote:
>> Hi
>>
>> I've a very big RDF/XML file (11 GB) and I'm trying to load it into
>> Virtuoso using DB.DBA.RDF_LOAD_RDFXML_MT
>>
>> It seems to be working, but since I haven't found a way to obtain a
>> progress var or any kind of feedback I'm not sure if it is really
>> working.
>> Is there any way to check this?
>> The process has been running for almost 3 hours :(
>>
>> regards
>> Lorena
>
> ------------------------------------------------------------------------------
> Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
> MVPs and experts. ON SALE this month only -- learn more at:
> http://p.sf.net/sfu/learnnow-d2d
> _______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d
_______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
