Limit db:get() calls with fuzzy search and XForms

Von: Laurent THEVENON via BaseX-Talk <basex-talk at mailman.uni-konstanz.de> Gesendet: Montag, 8. Juni 2026 16:11 An: basex-talk at mailman.uni-konstanz.de Betreff: [basex-talk] Limit db:get() calls with fuzzy search and XForms Hello, I'm creating forms using XForms and BaseX. For some of them, I need to use a lot of data, so I've set up a search form that loads an XForms instance at every change in the field, from an internal link like this: /xml/persons/search?query=[search field content]. BaseX responds with RESTXQ: declare %rest:path('/xml/persons/search') %rest:produces('application/xml') %rest:query-param('query', '{$query}') function searchPersons($query){ <persons> db:get(myBase)//*:persons[ . contains text {fn:lower-case($query)} using fuzzy] </persons> }; Although I only enable searches with 3 characters or more, each change to the search field creates a new call to db:get(), which, if I understand correctly, is not recommended. Could using a variable in the RESTXQ file solve this problem ? Something like : declare variable $project:allPersons := db:get(myBase)//*:persons and then only using this new var ? If not, how can I avoid to call to much db:get()? Thank you very much for your answers. Regards, Laurent

Le 22/06/2026 à 11:15, Christian Grün a écrit : > Hi Laurent, > > In principle it is completely fine to use db:get. > > Are you trying to speed up the runtimes of your queries, or do you have other reasons/motivations to revise your code? > > Cordialement, > Christian > ________________________________________ > > Von: Laurent THEVENON via BaseX-Talk<basex-talk at mailman.uni-konstanz.de> > Gesendet: Montag, 8. Juni 2026 16:11 > An:basex-talk at mailman.uni-konstanz.de > Betreff: [basex-talk] Limit db:get() calls with fuzzy search and XForms > > Hello, > > I'm creating forms using XForms and BaseX. > For some of them, I need to use a lot of data, so I've set up a search form that loads an XForms instance at every change in the field, from an internal link like this: > > /xml/persons/search?query=[search field content]. > > BaseX responds with RESTXQ: > > declare > %rest:path('/xml/persons/search') > %rest:produces('application/xml') > %rest:query-param('query', '{$query}') > function searchPersons($query){ > <persons> > db:get(myBase)//*:persons[ . contains text {fn:lower-case($query)} using fuzzy] > </persons> > }; > > Although I only enable searches with 3 characters or more, each change to the search field creates a new call to db:get(), which, if I understand correctly, is not recommended. > Could using a variable in the RESTXQ file solve this problem ? Something like : > > declare variable $project:allPersons := db:get(myBase)//*:persons > > and then only using this new var ? > > If not, how can I avoid to call to much db:get()? > > Thank you very much for your answers. > > Regards, > > Laurent > > > >