search

vesta-webtrees-2-custom-modules / vesta_extended_relationships

⚶ Vesta Extended Relationships (Webtrees 2 Custom Module)
https://cissee.de/
GNU General Public License v3.0
11 stars 4 forks source link

Very slow rendering (+4 seconds) #82

Closed ronaaron closed 2 years ago

ronaaron commented 2 years ago

Hello - I just upgraded to the latest Webtrees release, and updated Vesta as well. I'm actually now using your git version, not the released one, in hopes it would fix this issue (it didn't).

The extended relationships does two fetches which are taking a long time, it would be great if they could be done at least in parallel:

image

ric2016 commented 2 years ago

The second request is done via Ajax because it may take longer. At this point, the page should be rendered though. The first request determines, among other things, the inputs for the second one, so it's not really possible to run them in parallel.

In any case, the first request shouldn't be substantially slower than a similar request for the original webtrees tab. It may be slow e.g. due to a large number of facts, such as historic events.

ronaaron commented 2 years ago

Hmm. I wonder if there isn't some way to make the first request get more information? In any event, I can try to make the database run faster on the admittedly slow machine it's on.

ric2016 commented 2 years ago

That would slow down the initial rendering of the page.

Can you confirm that the time is about the same when using the regular tab, or is it substantially slower?

ronaaron commented 2 years ago

From what I can see, any page takes about as long.

ronaaron commented 2 years ago

A point of information:

A particular page with basically no links takes almost 6 seconds to load. After I remove all the vesta stuff (e.g. clean out modules_v4), the same page takes 450ms to load.

That implies it's not the database load per se, but something to do with the vesta modules.

ric2016 commented 2 years ago

I may have to analyze this further - I'm currently on holiday though, so this will have to wait (about two weeks).

ronaaron commented 2 years ago

Thank you, I'm most interested. Have a good vacation.

ric2016 commented 2 years ago

Is this still an issue? Is there a way for me to reproduce this on your server?

ronaaron commented 2 years ago

It should still be an issue, but I disabled the vesta stuff because it was really slowing the system down.

ric2016 commented 2 years ago

I'm afraid I cannot reproduce this on my servers.

ric2016 commented 2 years ago

(reopen if there is a way to reproduce this)