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 <rogenry.av...@gmail.com> Inviato: venerdì 27 ottobre 2023 06:55 A: users@jackrabbit.apache.org 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 r.gambe...@westpole.it 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:priv...@westpole.it) 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
