[Virtuoso-users] Disabling logging & transactions with DB.DBA.TTLP_MT

Hi, Quick question regarding DB.DBA.TTLP_MT. I run the following command: DB.DBA.TTLP_MT (file_to_string_output ('some.n3'), '', 'http://foo/bar/' 0, 0, 4, 0); "some.n3" is about 30G big with a few hundred million triples. I thought that this would disable transactions and logging, but it d

Re: [Virtuoso-users] How to get full running SPARQL queries; status() trunc them

Hi Hugh, > You can enable Virtuoso query logging as detailed at: > > http://docs.openlinksw.com/virtuoso/ptune/ > > in the "Query Logging” section where many metrics on queries, profile, > compilation, execution time etc information can be veiwed and analysed ... Wonderful thanks! This i

[Virtuoso-users] How to get full running SPARQL queries; status() trunc them

Hi, I am wondering if there is a way to get the full running SPARQL queries because status() is truncating them and I can't see what is the query that is currently running in most of the cases. Thanks, Fred -- Chec

Re: [Virtuoso-users] virtuoso Sorted TOP clause specifies more then 1000000 rows

Hi Phillip Virtuoso 22023 Error SR353: Sorted TOP clause specifies more then 100 rows to sort. Only 1 are allowed. Either decrease the offset and/or row count or use a scrollable cursor Yes, you have to use subqueries for that. Instead of writing: select ?s ?pref from

Re: [Virtuoso-users] unable to delete typed literal

Hi all, I think this is the same as this error I reported on GitHub: https://github.com/openlink/virtuoso-opensource/issues/247 Thanks, Fred Hi Jürgen , Thanks for reporting, we are looking into this ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http:

Re: [Virtuoso-users] Issues with UTF-8 characters when importing big N3 files

Hi, I think I found the issue. It was that there was one bad UTF-8 character in the whole document. That should have lead the parser to select a different encoding because of the inconsistency into the encoding of the file. When I was "slicing" it, I had slices properly encoded into UTF-8, an

[Virtuoso-users] Issues with UTF-8 characters when importing big N3 files

Hi, I am currently experiencing data ingest issues with Virtuoso 6.1.6 and 6.1.8. All the accented characters of the N3 file I am importing are replaced by question mark characters "?". The file I am importing is 242M big. I am using the following command to import it into Virtuoso:

Re: [Virtuoso-users] Possible compatibility between 6.1.16 and 6.1.8?

Hi Hugh, You can track withthe atom feed, to see when a fix for this issue has been published: https://github.com/openlink/virtuoso-opensource/commits/develop/6.atom or you could log the issue on the git tracker and would get notification when the issue has been fixed ... https://github.

Re: [Virtuoso-users] Possible compatibility between 6.1.16 and 6.1.8?

/ 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 30 Jan 2014, at 18:23, Frederick Giasson <mailto:f...@fgiasson.com>&

[Virtuoso-users] Possible compatibility between 6.1.16 and 6.1.8?

Hi, I am wondering if I found a compability issue between VOS 6.1.6 and 6.1.8. I did compile VOS 6.1.8 without any issues, then I ran with with a VOS 6.1.6 database file. There was no issues, and everything was working as expected, until I use the following SPARQL query: == select ?

[Virtuoso-users] Long read issues with PHP odbc

Hi Everybody, I am facing long read issue with one of my server (when sparqling). The server runs: (1) Virtuoso 5.12.3041 (2) PHP 5.3.2 (3) It uses the default unixodbc drivers that comes with ubuntu (4) I am using DB.DBA.SPARQL_EVAL to wrap the sparql queries via the PHP-ODBC API. So, bas

Re: [Virtuoso-users] RDF views and caching the data locally

Hi Mark, I need one further point of clarification. Is it possible to restrict the triples dumped via this procedure? Some of the rdf views being used will have billions of triples within them. It is not practical to dump the lot daily. Ideally only triples required by the individual reports

Re: [Virtuoso-users] Virtuoso-opensource Installation issue: glib?

Hi Bill, Bill: first, I did CC this message to the Virtuoso Users List since it is mostly related to Virtuoso building questions. Virtuoso mailing list: this is a message from Bill Anderson that has some issues installing VOS. Hi all, I'm relatively new to construtscs and last week I had a

Re: [Virtuoso-users] Inserting data into an arbitrary graph with HTTP

Hi Kjetil, Try one of these PL functions: DB.DBA.TTLP_MT() DB.DBA.RDF_LOAD_RDFXML_MT() Yeah, I am aware of them, but how can we use them from the SPARQL endpoint? Right, you will need an ODBC connection to send them. Otherwise I don't think you can do this via the SPARQL endpoint.

Re: [Virtuoso-users] Inserting data into an arbitrary graph with HTTP

Hi Kjetil, Try one of these PL functions: DB.DBA.TTLP_MT() DB.DBA.RDF_LOAD_RDFXML_MT() Take care, Fred All, We need to insert a few hundred triples in a certain graph over HTTP and we are struggling to do that. The graph name we use is not dereferenceable, i.e. there is no server there,

Re: [Virtuoso-users] Scalable SPARQL querying in PHP?

Hi Daniel, I've been using the ARC PHP libraries to query my local Virtuoso SPARQL end point. While this works fine for small amounts of data, the Why do you need the ARC libraries? You can just query Virtuoso via an ODBC connection. This is very scalable and there should be no pe

Re: [Virtuoso-users] Scalable SPARQL querying in PHP?

Hi Daniel, I've been using the ARC PHP libraries to query my local Virtuoso SPARQL end point. While this works fine for small amounts of data, the memory usage of paging through hundreds of pages of results is too much for my PHP process to handle. Is there a better way to do SPARQL quer

Re: [Virtuoso-users] Virtuoso performance for bookmarking?

Hi Jens, Strange. Try sparqling the endpoint to get triples from resources defined after this one: 6690544 That way we will know if it continues to index the file. If not, then I think I would kill the instance, check what is the last resource being indexed (last checkpoint), split the du

Re: [Virtuoso-users] Virtuoso performance for bookmarking?

Hi Jens, Could you read the dump file until that line? I am wondering about what is written in the dump near this record. As Hugh said, this is quite old and probably that some things changed :) Thanks, Fred Hi Jens, Can you provide copy or the URL to download the geonames dataset you a