Re: [Virtuoso-users] best way to update large RDF stores with triples of a large document

2015-04-18 Thread Hugh Williams
Hi Gang, The “with_delete” option is only designed to work with nquads with all nquads of the same graph name being in the same dataset file. You can use sparql delete for for large changes to the database it will be rather inefficient as even when updating an existing triples it will always d

Re: [Virtuoso-users] virtuoso striping

2015-04-18 Thread Hugh Williams
Hi Gang, The latest Virtuoso 6+ database engines automatically automatically compact themselves, thus whilst with earlier release we use to have the “vacuum” [1] function it is no longer necessary. The most compact you can get the database would be to dump and restore the database , when it w

Re: [Virtuoso-users] check if a stored procedure exists

2015-04-18 Thread Gang Fu
Thanks a lot, Marc! I want to create a procedure to drop a given procedure name if it exists: CREATE PROCEDURE drop_procedure_if_exist ( IN pname VARCHAR ) { DECLARE pcount INTEGER; SELECT count(*) as pcount FROM sys_procedures WHERE p_name LIKE pname; IF (pcount>0) DROP PROCEDURE pname; } But I

Re: [Virtuoso-users] Unable to bulk load nquads in Virtuoso

2015-04-18 Thread Hugh Williams
Hi Maria, For the "GPF: Dkbox.c:638 Double free” error, is a core file being created when the server crashes ( note core size for user account should be set to be unlimited with command “ulimit -c unlimited” first), as if so you can create a debug unstripped Virtuoso binary, recreate the core w

Re: [Virtuoso-users] Error to load file on Virtuoso from iSQL

2015-04-18 Thread Hugh Williams
Hi Julio, Not sure what you are highlighting as a problem here if the only difference is in the graph name between what works/loads and what does not ? After the load of the problem dataset what does the following returns as the available graphs and counts: SPARQL SELECT ?graph (count(?s) a