Re: R: [Mittente sospetto]:How to improve Jackrabbit response times?

[Rogenry Avila <ro...@gmail.com>]

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 <ro...@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.Gambelli@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:privacy@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