Re: [Virtuoso-users] Export RDF to a file

2007-04-30 Thread imikhailov
Alex, >> Is there any way I can write out to a file as I go - rather than >> storing it all in an in-memory string stream? > Ah, I figured out a way to do this.. I write to the string stream as I go, and every N times through the loop I append it to a file and flush the string stream. The stri

Re: [Virtuoso-users] Export RDF to a file

2007-04-30 Thread Alex Black
Ah, I figured out a way to do this.. I write to the string stream as I go, and every N times through the loop I append it to a file and flush the string stream. - Alex > -Original Message- > From: virtuoso-users-boun...@lists.sourceforge.net > [mailto:virtuoso-users-boun...@lists.sourcef

Re: [Virtuoso-users] Export RDF to a file

2007-04-30 Thread Alex Black
Thanks again Ivan. Is there any way I can write out to a file as I go - rather than storing it all in an in-memory string stream? - Alex > -Original Message- > From: imikhailov [mailto:imikhai...@openlinksw.com] > Sent: Monday, April 30, 2007 1:49 PM > To: Alex Black; virtuoso-users@li

Re: [Virtuoso-users] Export RDF to a file

2007-04-30 Thread imikhailov
Alex, > Will this method work with relational data that I have setup an RDF view for? The idea will work, thw procedure will not. It access directly to RDF_QUAD ignoring any quad maps ('RDF views'). > When I invoke this method with my graph, I get an empty file, which I assume is because I have

Re: [Virtuoso-users] Export RDF to a file

2007-04-30 Thread Alex Black
Thanks Ivan, that looks promising. Will this method work with relational data that I have setup an RDF view for? When I invoke this method with my graph, I get an empty file, which I assume is because I have not figured out how to speicfy my quad storage...? I'm trying this, and it doesn't l

Re: [Virtuoso-users] Export RDF to a file

2007-04-30 Thread imikhailov
Alex, CONSTRUCT is definitely not the best way, because it creates in-memory dictionary of created triples, 1.8.Gb dictionary of this sort may abort client connection by 'memory low' alert. Latest commercial Virtuoso build contains function DB.DBA.RDF_GRAPH_TO_TTL (in graph_iri varchar, inout se

Re: [Virtuoso-users] Export RDF to a file

2007-04-30 Thread Alex Black
Ok, thanks Ivan. Related to this, are there any other options for exporting triples to a file? If I want to export my 1.8gb of data to RDF TTL, is this the most performant method in Virtuoso? - Alex > -Original Message- > From: imikhailov [mailto:imikhai...@openlinksw.com] > Sent: Mon

Re: [Virtuoso-users] Export RDF to a file

2007-04-30 Thread Alex Black
Hi Ivan, I've hit a small problem with CONSTRUCT - when I use construct (instead of select), they query seems to take forever, I waited about 10 mins and then gave up. This query returns 10 rows and returns instantly: sparql define input:storage Sel

Re: [Virtuoso-users] Export RDF to a file

2007-04-30 Thread Alex Black
Thanks very much Ivan, that helps a lot! > -Original Message- > From: imikhailov [mailto:imikhai...@openlinksw.com] > Sent: Saturday, April 28, 2007 3:19 PM > To: Alex Black > Cc: virtuoso-users-boun...@lists.sourceforge.net > Subject: RE: [Virtuoso-users] Export RDF to a file > > Hello