alfio-event / alf.io-PI

Raspberry-Pi 3 version for offline check-in and label printing
https://alf.io
GNU General Public License v3.0
14 stars 8 forks source link

reprint badge: improve performance on search #17

Open cbellone opened 7 years ago

cbellone commented 7 years ago

We should save first, last name and email address directly as columns and use them in the where clause instead of searching into the JSON Blob

syjer commented 7 years ago

additional possible improvements (http://www.hsqldb.org/doc/2.0/guide/dbproperties-chapt.html): enable compression of clob/lob and the script -> less data to write and read from the sdcard

syjer commented 7 years ago

use the following jdbc url: jdbc.url=jdbc:hsqldb:file:alfio;hsqldb.lob_compressed=true;hsqldb.script_format=3

(database must be recreated)

syjer commented 7 years ago

note: in theory it should be way faster now. To check!