This content has been marked as final.
Show 7 replies
-
1. Re: Joseki datasource configuration / statement caching
alwu-Oracle Jul 21, 2010 9:51 PM (in response to 766393)Hi,
What is your max memory setting for WLS?
Thanks,
Zhe Wu -
2. Re: Joseki datasource configuration / statement caching
766393 Jul 22, 2010 10:22 AM (in response to alwu-Oracle)Hi,
2GB for initial / max memory.
Joseki is the only application deployed.
I only ran 35 queries (consecutively) before memory ran out.
These queries were quite complex and included ARQ non-SPARQL capabilities. They were pretty much exactly the same, except for a FILTER part.
Anyway, in my case, query performance does not seem to be crippled by the disabling of statement caching, so I will probably leave it disabled.
Regards,
Julien -
3. Re: Joseki datasource configuration / statement caching
alwu-Oracle Jul 22, 2010 7:05 PM (in response to 766393)That is strange. Some other folks have successfully run many, many more queries than 35 without a problem.
Can you please provide a typical complex query using non-SPARQL capabilities?
Thanks,
Zhe Wu -
4. Re: Joseki datasource configuration / statement caching
715399 Jul 22, 2010 7:08 PM (in response to 766393)Hi Julien,
Also, how many connections do you have in your datasource? Each connection has its own statement cache.
Regards,
Vladimir -
5. Re: Joseki datasource configuration / statement caching
alwu-Oracle Jul 22, 2010 8:31 PM (in response to 766393)I just confirmed with another user on the statement caching setting in WLS. The settings are LRU + 10, the default. That user has not encountered the problem you described, after running many rather complex queries. Need more information to triage. -
6. Re: Joseki datasource configuration / statement caching
766393 Jul 23, 2010 10:24 AM (in response to alwu-Oracle)Hi,
I had the issue even with only one connection in the connection pool (defined in joseki-config.ttl).
Regarding the queries, I am sorry, but I can't discuss them much due to the confidentiality of the matter.
However I can say that the SPARQL query that was mainly used involved :
- ORACLE_SEM_FS_NS settings : DOP=8, timeout and qid
- (sometimes) a nested SELECT
- an UNION between several graph patterns, each of them using FILTERs
- apf:splitURI and fn:substring
- around 35 triple patterns
- several FILTERs (REGEX, ISURI, etc)
- finally, ORDERing.
Each query resulted in thousands of lines.
Model is a ~17,000,000-triple raw (no inference, no virtual model, etc) RDF model.
Joseki settings were pretty much the default one. As for the datasource.
To be honest, I doubt that statement caching would be of any use in my case since it is very unlikely that the same queries will be sent several times.
As I said, disabling it did not affect the query performance much.
It is clearly not really an issue for me (I mainly talked about it here in case someone else had OoMs with Joseki and was trying to find out why), so if I am the only isolated user who encountered this, it might not be useful to investigate further...
Thanks,
Regards,
Julien -
7. Re: Joseki datasource configuration / statement caching
alwu-Oracle Jul 23, 2010 11:07 PM (in response to 766393)Thanks for the information. Maybe we can take it offline? I'd like to get to the bottom of it.
Zhe Wu