Hi Christian

Yes my goal is to speed up my queries.

But I don't a real speed issue, I'm just trying to produce efficient code. And my mind, multiples calls au db:get() wasn't a good pratice.

So if it's fine to use db:get() in my case, I don't really have an issue here :)

Thanks a lot for you answer

Mit freundlichen Grüßen

Laurent

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@mailman.uni-konstanz.de>
Gesendet: Montag, 8. Juni 2026 16:11
An: basex-talk@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