[Koha-devel] SQL Reports

[SUZUKI Arthur]

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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: guidedreport.sql
Type: application/sql
Size: 1065 bytes
Desc: not available
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20170106/359b5166/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: rawsql.sql
Type: application/sql
Size: 892 bytes
Desc: not available
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20170106/359b5166/attachment-0001.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: guidedreport4Koha.sql
Type: application/sql
Size: 1102 bytes
Desc: not available
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20170106/359b5166/attachment-0002.bin>