Rather than use an oracle database as the back-end store for our sparql service, I am using TDB: a back end that comes with JENA. It’s just some files in a local directory.
This means that the boa content has to go on the web server, but that’s ok. it’s about 42 gig.
And my God it’s fast. Even checking a regex against all names is … tolerable. Several seconds.
Must add search fields for the names and authors – converted to uppercase, all diacritics removed. Perhaps even add taxamatch conversion.
Also need to write some demo pages and host them on biodiversity.org.au . My demo pages use AJAX, which creates cross-site scripting issues if the are not hosted there.