AW: Query Timed

[Andreas Schwarte]

Hello,

 

This sounds like a strange handling in the database.

 

Did you try to rewrite your query to remove the “rdf:type” graph pattern? In the worst case this is a full table scan for all “Person” instances, and only afterwards it gets filter on QWE users. It might help in your case (depending on the data) to re-order the query and use blocks such that the “sl:division “QWE” part gets executed first, e.g.

 

SELECT DISTINCT ?user WHERE{ 

 

                { ?oracleDbUser sl:division "QWE"^^xsd:string. }

              ?user sl:oracleDbUser ?oracleDbUser. 

                ?user rdf:type <http://www.xxxxxxxx.com/xxxxxxx/Person>. 

} 

 

Note that using DISTINCT often hides problems in the underlying data (e.g. large result sets). This query looks like it should deliver the same results without DISTINCT.

 

Also you can try to use the “asynch” functionality in the widget configuration to load the widgets in an own background thread.

 

Note: in the upcoming 8.1 release we introduce a protection layer for the database which allows to configure the parallel queries that get executed at the same time using a semaphore (e.g. 2 queries in parallel). This is configurable for named configurations (e.g. “longRunningQueries”).

 

Hope this helps,

Andreas

 

Von: iwb-dis...@googlegroups.com [mailto:iwb-dis...@googlegroups.com] Im Auftrag von Deesh Banneheka
Gesendet: Freitag, 15. September 2017 17:20
An: Information Workbench Discussions <iwb-dis...@googlegroups.com>
Betreff: Query Timed

 

Hi All

 

I have problem with a wiki page at loading.

Its "Query timed out:" error.
Unfortunately, it is not that complicated queries and number of all triples are about 1 million as well.

 

There are 3 TableResult Widget, that data is displayed.

If I run the single query, works within 2-3 seconds.

When all 3 TableResult Widget are loaded at once, there is usually timeout error.

 

a examples query.: (how its looks like)

SELECT DISTINCT ?user WHERE{ 

                ?user rdf:type <http://www.xxxxxxxx.com/xxxxxxx/Person>. 

                ?user sl:oracleDbUser ?oracleDbUser. 

                ?oracleDbUser sl:division "QWE"^^xsd:string. 

} 

 

Question:

1. Is there a way each TableResult widget is loaded individually? (one after another)

2. What solution do you recommend or How can I fix this issue?

 

Thanks a lot for the feedback.

 

Cheers

Jagath

--
You received this message because you are subscribed to the Google Groups "Information Workbench Discussions" group.
To unsubscribe from this group and stop receiving emails from it, send an email to iwb-discussio...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.