Hello Devs, Happy new year! My problem today is the following : I'm writing a Koha plugin to display recommendations on the OPAC: http://github.com/liliputech/koharecommenderengine The way I'm doing it involve modifying the web server configuration, which is *not so convenient*. I wanted to reformat part of my code to place the "SQL Select" part of my plugin in a public report to be able to access it with the following url : http://[koha-url]/cgi-bin/koha/svc/report?id=[reportId]&sqlparam=[biblionumber]&sqlparams=[number-of-year-to-search] The problem is the first method gives good performance results while the second one is so damn slow. The "guidedreport.sql" is 100 times slower than "rawsql". Any advice? I used the tutorial here : https://wiki.koha-community.org/wiki/SQL_Reports_Library#Runtime_Variables Many thanks in advance. PS : Hi Baptiste, much welcomes to you! -- Arthur SUZUKI Service informatique des bibliothèques BIBLIOTHÈQUES UNIVERSITAIRES Université Jean Moulin Lyon 3 6 Cours Albert Thomas - B.P. 8242 – 69355 Lyon Cedex 08 ligne directe : +33 (0)4 78 78 79 16 | http://bu.univ-lyon3.fr L'Université Jean Moulin est membre fondateur de l'Université de Lyon