Escalus

Hey thanks that helps. But is there a way to continue the results like in the playground?

Thanks for your reply, It took some time to execute all this queries. > Has the data, i.e., number of triples in the database, increased since the upgrade to the...

How much space do I need on for this? Does this only save this 1 broken QUAD in a new table and replace the old entries with it?

I repaired all 5 tables and the result of this queries is now 0. Sadly the problem with the optimization of this queries still exists. the `?pub fgi:hasTopic ?topic` is...

> Can you provide a query(s) [`profile`](https://vos.openlinksw.com/owiki/wiki/VOS/VirtTipsAndTricksAnalyzingSPARQLQuery) plan (rather than an explain plan) with the `SET PROFILE ON;` command run from `isql`? This will enable the query compilation and execution...

Yes the plan being used causes the 0,1s to 66s difference. We create the nt-files (gunziped) with a separate transformer and use the `isql` [bulk import](https://vos.openlinksw.com/owiki/wiki/VOS/VirtBulkRDFLoader) for the weekly updates....

His helps to push the optimizer in the right direction. The `index S` option helps to speed the queries up. The `index O/P` and `hash `options are all slow. Here...

Yes it was completely new created with the `7.2.9` binary. I changed the `IndexTreeMaps` setting back to its default. In my last checkpoint from today I got some warnings: `cursor...

No it started before. Here is our log since the last start [virtuoso.log](https://pastebin.com/ALkbwN45)

This was only a snippet. You can the `10:22:00 Server shutdown complete` at the end of the log. There was nothing special after the restart yesterday.