Hello,
The two principal types of queries are like:
SELECT * FROM [pho_nt:pentahoFile] as file
WHERE (file.[pho_mix:type] = 'template' OR LOCALNAME(file) LIKE '%.prpt')
ORDER BY LOCALNAME(file) ASC
and
SELECT * FROM [pho_nt:pentahoFile] as file
LEFT OUTER JOIN [pho_nt:pentahoFile] as template
ON template.[jcr:uuid] = file.[pho_mix:template]
WHERE file.[pho_mix:type] = 'report'
ORDER BY LOCALNAME(file) ASC
Using limit in the query doesn't help much because since there is a
sort, Jackrabbit retrieves all nodes anyway. I also traied setting
useNativeSort=true, so the sorting is done by Lucene. The biggest
problem is with the second query because, in addition to the join, it is
where there are more files.
Regars,
Rogenry
El 27/10/23 a las 2:42 a. m., Raffaele Gambelli escribió:
Hello,
first of all I would suggest the reading of these pages:
* https://jackrabbit.apache.org/archive/wiki/JCR/Search_115513504.html*
* https://jackrabbit.apache.org/archive/wiki/JCR/Performance_115513486.html
In my experience too setting properly the bundlecachesize resulted in
performance increasing, I found very useful article, this one
https://www.jahia.com/blog/performance-sizing-the-jackrabbit-bundle-cache-properly
Unfortunately the first query suffers a bit, which is your jcr query?
-----Messaggio originale-----
Da: Rogenry Avila <[email protected]>
Inviato: venerdì 27 ottobre 2023 06:55
A: [email protected]
Oggetto: [Mittente sospetto]:How to improve Jackrabbit response times?
Hello,
I have developed a solution for a product that uses Apache Jackrabbit
2.16.5 for its repository, configured with a bundle MySqlPersistenceManager. It
meets all the requirements, but I think the responses to queries are slow. On
my laptop, for 6k files it takes 10s or so. The results improved a little after
increasing the persistance manager's bundleCacheSize, but the first query still
continues to take the same amount of time. Is it possible to improve these
response times?
I haven't found much documentation online. I would appreciate any help.
Thank you,
Rogenry
[https://westpole.it/firma/westpole_cegeka_logo.jpg]
Raffaele Gambelli
Research & Development
P +390518550576
M 3371641888
E [email protected]
W https://westpole.webex.com/meet/R.Gambelli
A Via Ettore Cristoni, 84 - 40033 Casalecchio di Reno
[https://westpole.it/firma/website.png]<https://westpole.it>
[https://westpole.it/firma/twitter.png] <https://twitter.com/WESTPOLE_SPA>
[https://westpole.it/firma/linkedin.png] <https://www.linkedin.com/company/westpole-italia/>
[https://westpole.it/firma/mortarboard.png] <https://careers.westpole.eu/>
This email for the D.lgs.196/2003 (Privacy Code) and European Regulation
679/2016/UE (GDPR) may contain confidential and/or privileged information for
the exclusive use of the intended recipient. Any review or distribution by
others is strictly prohibited. If you are not the intended recipient, you must
not use, copy, disclose or take any action based on this message or any
information here. If you have received this email in error, please contact us
(email:[email protected]) by reply email and delete all copies. Legal
privilege is not waived because you have read this email. Thank you for your
cooperation.
[https://westpole.it/firma/ambiente.png] Please consider the environment before
printing this email
