Re: [Virtuoso-users] Performance weirdness REGEX vs. bif:contains

2010-03-24 Thread Ivan Mikhailov
Hello Sebastian, That's a bit weird, but with unspecified graph I should ask first what indexes are in use? 1073 properties is not so much, so you have less than 1000 graphs of ontologies and maybe much more graphs other than ontologies. If it's a case then I'd recommend to experiment with an add

Re: [Virtuoso-users] Custom RDF -> SQL Table Mapping

2010-03-24 Thread Kingsley Idehen
Jesse Sightler wrote: I see that the process of generating an RDF view on an existing SQL-based table structure is generated by a mapping file. Is the mapping process documented? Ie, how difficult would it be to generate a mapping by hand based upon custom requirements? Once you understand ho

[Virtuoso-users] Custom RDF -> SQL Table Mapping

2010-03-24 Thread Jesse Sightler
I see that the process of generating an RDF view on an existing SQL-based table structure is generated by a mapping file. Is the mapping process documented? Ie, how difficult would it be to generate a mapping by hand based upon custom requirements? Thanks, Jess

[Virtuoso-users] Performance weirdness REGEX vs. bif:contains

2010-03-24 Thread Sebastian TrĂ¼g
In my rather simply query parser which allows users to write stuff like "hastag:foobar" I am currently using the following query to match "hastag" to an actual property (the db contains a bunch of ontologies, each loaded in their own graph with a total of 1073 properties in a database of about 1099