Hi Holger,
On May 30, 7:24 am, Holger Knublauch <[email protected]> wrote: > Hi Paul, > > do you know when the slowness started for you? >From the first moment already. Is not surprising since the workflow is as follows. Read in csv in Google Refine, clean, reconcile and export to RDF ttl. Then import the ttl file into Sesame via the Sesame Workbench. Connect to Sesame from TBC to do some additional editing and constraint checking. >Could it in fact be > related to bnodes? Yes, that's a valid hypothesis. >If so, could you try with a model that does not use > bnodes? Yes, will do early next week. >Also what is the physical storage model that you interface via >Sesame (maybe the bnode handling is different on each platform)? It is in this case a native Java store with RDF Schema. > In > general bnodes are rather fragile when it comes to databases. Within the Sesame environment itself there doesn't seem to be any issue. Paul > > Thanks > Holger > > On 5/29/2012 23:04, PaulZH wrote: > > > > > > > > > Context: > > Sesame 2.6.5 > > TBCME Version: 3.6.0.v20120419-1246R > > on Mac Mac OS X Lion 10.7.4 (11E53) > > with Java version "1.7.0_04" > > Java(TM) SE Runtime Environment (build 1.7.0_04-b21) > > Java HotSpot(TM) 64-Bit Server VM (build 23.0-b21, mixed mode) > > > All actions (writing, querying) to a remote sesame happen very slow. > > > - Writing a few new triples takes 10 minutes. > > - Following query > > SELECT * > > WHERE { > > ?a a vl:School. > > ?a vcard:adr ?address. > > ?address vcard:locality ?locality. > > FILTER (?locality = "Mortsel") > > } > > which is carried out in less than a second within the sesame > > workbench, takes 10 minutes in TBCME. > > > One thing I notice is that errors are thrown related to blank nodes: > > null > > Warning > > Tue May 29 14:37:09 CEST 2012 > > Failed to convert node: @node16tvbnmeqx27438 > > > java.lang.IllegalArgumentException: Not a valid (absolute) URI: > > @node16tvbnmeqx27438 > > at org.openrdf.model.impl.URIImpl.setURIString(URIImpl.java:68) > > at org.openrdf.model.impl.URIImpl.<init>(URIImpl.java:57) > > at > > org.openrdf.model.impl.ValueFactoryImpl.createURI(ValueFactoryImpl.java: > > 38) > > at org.topbraid.sesame2.mapping.Jena2Sesame.getURI(Jena2Sesame.java: > > 76) > > at org.topbraid.sesame2.mapping.Jena2Sesame.getValue(Jena2Sesame.java: > > 87) > > at > > org.topbraid.sesame2.graph.RepositoryGraph.graphBaseFind(RepositoryGraph.java: > > 82) > > at com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:240) > > at > > org.topbraid.core.graph.DelegatingGraph.delegateFind(DelegatingGraph.java: > > 243) > > at org.topbraid.core.graph.CachingGraph.addToCache(CachingGraph.java: > > 145) > > at > > org.topbraid.core.graph.AbstractCachingGraph.find(AbstractCachingGraph.java: > > 178) > > at > > org.topbraid.core.graph.AbstractCachingGraph.find(AbstractCachingGraph.java: > > 168) > > at org.topbraid.core.graph.DelegatingGraph.find(DelegatingGraph.java: > > 113) > > at org.topbraid.core.graph.BufferingGraph.find(BufferingGraph.java: > > 380) > > at org.topbraid.core.graph.BufferingGraph.find(BufferingGraph.java: > > 402) > > at > > com.hp.hpl.jena.graph.compose.MultiUnion.multiGraphFind(MultiUnion.java: > > 187) > > at > > com.hp.hpl.jena.graph.compose.MultiUnion.graphBaseFind(MultiUnion.java: > > 166) > > at com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:240) > > at com.hp.hpl.jena.graph.impl.GraphBase.graphBaseFind(GraphBase.java: > > 260) > > at com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:257) > > at > > com.hp.hpl.jena.rdf.model.impl.ModelCom.listStatements(ModelCom.java: > > 378) > > at > > com.hp.hpl.jena.rdf.model.impl.ModelCom.listStatements(ModelCom.java: > > 383) > > at > > com.hp.hpl.jena.rdf.model.impl.ResourceImpl.listProperties(ResourceImpl.java: > > 157) > > at > > org.topbraidcomposer.ui.ToolTipTexts.getToolTipText(ToolTipTexts.java: > > 38) > > at org.topbraidcomposer.widgets.row.editors.AbstractEditorText > > $10.handle(AbstractEditorText.java:487) > > at > > org.topbraidcomposer.ui.text.StyledTextNavigator.updateRange(StyledTextNavigator.java: > > 325) > > at > > org.topbraidcomposer.widgets.row.editors.AbstractEditorText.updateToolTipText(AbstractEditorText.java: > > 484) > > at org.topbraidcomposer.widgets.row.editors.AbstractEditorText > > $3.mouseMove(AbstractEditorText.java:139) > > at > > org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java: > > 211) > > at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) > > at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4125) > > at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1457) > > at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1480) > > at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1465) > > at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1270) > > at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java: > > 3971) > > at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3610) > > at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java: > > 2696) > > at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2660) > > at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2494) > > at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:674) > > at > > org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java: > > 332) > > at > > org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java: > > 667) > > at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java: > > 149) > > at > > org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java: > > 123) > > at > > org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java: > > 196) > > at > > org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java: > > 110) > > at > > org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java: > > 79) > > at > > org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java: > > 344) > > at > > org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java: > > 179) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: > > 39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: > > 25) > > at java.lang.reflect.Method.invoke(Method.java:597) > > at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622) > > at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577) > > at org.eclipse.equinox.launcher.Main.run(Main.java:1410) > > > Anything else I can investigate? -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en
