I am trying to perform a join operation between two large XML files (~490 MB and ~40 MB), which are the result of the automatic conversion of old sql dumps into XML files. I created two databases for the files. The query I wrote to join them is correct because it works when I limit the join to just a few items, but it never ends if I apply it to all items:

here is the xquery: https://git.informatik.uni-leipzig.de/celano/perseus_morpheus/-/blob/master/join_files.xq

here is the first file: https://git.informatik.uni-leipzig.de/celano/perseus_morpheus/-/blob/master/hib_parses.xml

here is the second file:  https://git.informatik.uni-leipzig.de/celano/perseus_morpheus/-/blob/master/hib_lemmas.xml

I have also tried to use the database module functions, but without success. Am I missing anything here? Thanks.

Ciao,

Giuseppe