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/koharecommenderengineThe 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
guidedreport.sql
Description: application/sql
rawsql.sql
Description: application/sql
guidedreport4Koha.sql
Description: application/sql
_______________________________________________ Koha-devel mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
