Hi Alexey,
We need to see the status(''); output either for the v6 or v7 instance being
used.
Also, where did you see these "rollback" messages ?
Using the Bulk loader the load_list table shows the status of the load of
datasets and any errors reported loading them to you see any ?
The ld_meter function can also be used for monitoring the process of the bulk
loader operation including load rates as detailed at:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksGuideLDMeterUtility
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 27 Jun 2013, at 22:00, Alexey Zakhlestin <[email protected]> wrote:
>
> On 28.06.2013, at 0:39, Hugh Williams <[email protected]> wrote:
>
>> Hi Alexey,
>>
>> For Virtuoso 6 the average size of a triple is about 31bytes, with the
>> default index schema as detailed in the followng FAQ document:
>>
>>
>> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSVirtuoso6FAQ#What%20is%20the%20storage%20cost%20per%20triple?
>>
>> What method are yu using for loading the data, as the recommended method is
>> using the Virtuoso Bulk loader functions at:
>>
>>
>> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtBulkRDFLoader
>
> Yes, that's what I use exactly.
>
>> Please provide the output of the status('') command run from isql so we can
>> see the state of the server when the load has apparently stopped, also what
>> does the top report as the memory and CPU usage of the Virtuoso server ?
>
> CPU is close to idle
> Memory was 100% used.
>
> I try to run import on a larger VM right now (30Gb of RAM). I managed to
> advance further but import process still gets slower and slower
> First files were imported in 1 minute time, and later files (of the same
> size) are taking tens of minutes.
>
> I don't have status() output right now (trying to upgrade to virtuoso/7).
> But I remember that I saw "rolled back" status for some of the import
> transactions and I wonder how could that happen.
> Obviously, there couldn't be any conflicts as server didn't do anything
> except bulk-loading rdf data.
>
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev
_______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
