Web based family history software

This Help forum is for issues relates to the latest release (1.7.8). For issues related to beta or github version please use their own Help forum.
Before asking for help please read "How to request help" by clicking on that tab above here."

Question [SOLVED] webtrees very slow after upgrade to 1.7.8

  • jopla
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
7 years 5 months ago #1 by jopla
Hello,

After the upgrade from 1.7.7 to 1.7.8 webtrees is very slow, especially in the Admin mode. I returned back to my last backup and it is indeed faster. I use PHP 7.0. What can be the reason that 1.7.8 so slow is?

Greetings,
Jop

Please Log in or Create an account to join the conversation.

More
7 years 5 months ago #2 by makitso
Replied by makitso on topic webtrees very slow after upgrade to 1.7.8
Jop,

It would be helpful if you noted the URL to your site and more details on what types of queries are specifically running slow.

Rob
www.skatekey.net ( webtrees 2.1 beta GitHub)
webtrees forum admin
PHP 8.1.21
Hosted at tigertech.net

Please Log in or Create an account to join the conversation.

  • jopla
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
7 years 5 months ago - 7 years 5 months ago #3 by jopla
Replied by jopla on topic webtrees very slow after upgrade to 1.7.8
Hi Makitso,

I don't know if the URL ( webtree.planje.info ) will help now, I downgraded to 1.7.7 and now it is faster ...

But I made a copy of the 1.7.8 version and put it on webtrees.planje.info

I just tested them near each other and the 1.7.7 is faster than the 1.7.8
Last edit: 7 years 5 months ago by jopla.

Please Log in or Create an account to join the conversation.

  • bertkoor
  • Offline
  • Platinum Member
  • Platinum Member
  • Greetings from Utrecht, Holland
More
7 years 5 months ago #4 by bertkoor
Replied by bertkoor on topic webtrees very slow after upgrade to 1.7.8
Sorry, but what type of page/diagram/report is exactly is slower / faster?
Could you maybe configure both to show the php time and sql query count at the page footer so it can be compared?
Because php7 is supposed to be much faster. Sounds like there's a performance regression so this needs to be looked at.

stamboom.BertKoor.nl runs on webtrees v1.7.13

Please Log in or Create an account to join the conversation.

More
7 years 5 months ago #5 by fisharebest
Replied by fisharebest on topic webtrees very slow after upgrade to 1.7.8
I cannot think of any changes between 1.7.7 and 1.7.8 that would affect performance.

If you look at the HTML source code for a page (e.g. Ctrl-U in firefox or chrome), and scroll to the bottom, you will see the exact time/memory/database that webtrees used to generate the page. e.g.
Code:
<!-- webtrees: 1.7.8 --><!-- Execution time: 0.181 seconds --><!-- Memory: 12,800 KB --><!-- SQL queries: 30 -->

Can you post your numbers for 1.7.7 and 1.7.8

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

  • jopla
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
7 years 5 months ago - 7 years 5 months ago #6 by jopla
Replied by jopla on topic webtrees very slow after upgrade to 1.7.8
Hi,

Is this what you suspect?
frontpage (without login)
1.7.8 <!-- webtrees: 1.7.8 --><!-- Execution time: 0.981 seconds --><!-- Memory: 2,560 KB --><!-- SQL queries: 40 -->
1.7.7 <!-- webtrees: 1.7.7 --><!-- Execution time: 0.261 seconds --><!-- Memory: 2,560 KB --><!-- SQL queries: 40 -->

hierarchie of places (with login)
<!-- webtrees: 1.7.8 --><!-- Execution time: 17,563 seconds --><!-- Memory: 6.656 KB --><!-- SQL queries: 1.169 -->
<!-- webtrees: 1.7.7 --><!-- Execution time: 0,602 seconds --><!-- Memory: 5.888 KB --><!-- SQL queries: 988 -->

my Page (with login)
<!-- webtrees: 1.7.8 --><!-- Execution time: 6,169 seconds --><!-- Memory: 3.840 KB --><!-- SQL queries: 33 -->
<!-- webtrees: 1.7.7 --><!-- Execution time: 0,961 seconds --><!-- Memory: 4.864 KB --><!-- SQL queries: 33 -->
Last edit: 7 years 5 months ago by jopla.

Please Log in or Create an account to join the conversation.

More
7 years 5 months ago #7 by fisharebest
Replied by fisharebest on topic webtrees very slow after upgrade to 1.7.8
I cannot think of a simple explanation.

You can browse all the code changes here
github.com/fisharebest/webtrees/commits/master

If you click on the <> link, you can download a .ZIP of the code after each change.

Look for changes between 1.7.7 (2016-07-17) and 1.7.8 (2016-09-23).

You can try to find the change that caused the problem, by installing each version.

For example, you could install a version from the middle date 2016-08-22, and see if it has the problem.

If yes, then it was a change before this date.
If no, then it was a change after this date.

You can repeat this process, of testing a middle version until you find the exact change that caused the problem.
I guess you may need to test 6-8 versions.

If you can do this, we can look at this change in more detail.

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

  • jopla
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
7 years 5 months ago #8 by jopla
Replied by jopla on topic webtrees very slow after upgrade to 1.7.8
Ok ...
Where can I find how to upgrade from a zip file? I ve never done that. Can I also downgrade or only upgrade?

Please Log in or Create an account to join the conversation.

  • bertkoor
  • Offline
  • Platinum Member
  • Platinum Member
  • Greetings from Utrecht, Holland
More
7 years 5 months ago - 7 years 5 months ago #9 by bertkoor
Replied by bertkoor on topic webtrees very slow after upgrade to 1.7.8

jopla wrote: Where can I find how to upgrade from a zip file?


That's described in the wiki: wiki.webtrees.net/en/Upgrading

jopla wrote: Can I also downgrade or only upgrade?


Doing a downgrade simular as an upgrade should not be an issue. Unless there are incompatible database scheme changes.. not likely now.

stamboom.BertKoor.nl runs on webtrees v1.7.13
Last edit: 7 years 5 months ago by bertkoor.

Please Log in or Create an account to join the conversation.

More
7 years 5 months ago #10 by fisharebest
Replied by fisharebest on topic webtrees very slow after upgrade to 1.7.8
> Can I also downgrade or only upgrade?

In general, no.

But for all the changes between 1.7.7 and 1.7.8, yes.

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

More
7 years 5 months ago #11 by rstoekenbroek
Replied by rstoekenbroek on topic Language setting has big impact
After a fresh installation for the first time with 1.7.8 WebTrees was dead slow! Everything!
Went down to 1.7.7 and things where better.
Then I found out, after upgrading to 1.7.8 again, the language setting of a user NOT to American English cuased the problems.

When using Dutch/Nederlands, or Plain English, dead-slow. On American/English very fast.

My hosting provider reported on their control panel: Your site might hit resource limits soon. You had 10.0K I/O usage out of 10.0K max I/O usage allowed.
Looking at the detailed charts I saw that this occured when running WebTrees as a NON-AmericanEnglish user.

RobST

Please Log in or Create an account to join the conversation.

  • jopla
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
7 years 5 months ago #12 by jopla
Replied by jopla on topic Language setting has big impact
I hadn't time yet to try all the between versions. But now testing with the language and that seems the problem ... Usual I work in Dutch.

Please Log in or Create an account to join the conversation.

More
7 years 5 months ago #13 by rstoekenbroek
Replied by rstoekenbroek on topic webtrees very slow after upgrade to 1.7.8
Still, despite using AmericanEnglish now all the time, performance fluctuates badly.
I don't have these problemes on another non-WebTrees site at the same hosting environment.

Just got long waiting time, asking for
stamboom.stoekenbroek.com/individual.php?pid=I325&ged=stoekenbroek

<!-- webtrees: 1.7.8 --><!-- Execution time: 5.993 seconds --><!-- Memory: 4,096 KB --><!-- SQL queries: 45 -->


DirectAdmin says:
Your site had no issues in the past 24 hours
Your site might hit resource limits soon
You had 10.0K I/O usage out of 10.0K max I/O usage allowed

RobST

Please Log in or Create an account to join the conversation.

More
7 years 5 months ago #14 by fisharebest
Replied by fisharebest on topic webtrees very slow after upgrade to 1.7.8
Are jopla and rstoekenbroek both using the same web host?

> Still, despite using AmericanEnglish now all the time, performance fluctuates badly.

The only difference between en-US and the other languages is the number of translations. en-US contains two or three. Other languages contain 4000.

However, with (any modern version of) PHP, this will make very little difference.

Perhaps you have other users (e.g. search engines) that are using other languages, and these are causing the slowdown.

> You had 10.0K I/O usage out of 10.0K max I/O usage allowed

I do not know what they mean by "I/O usage".

Is this limit per hour? per day? per minute?

Is this disk access? Translation does not require additional disk access. It takes one disk-access to read the translation files (whatever size), and after that they are in memory.

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

  • jopla
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
7 years 5 months ago #15 by jopla
Replied by jopla on topic webtrees very slow after upgrade to 1.7.8
my webhost is Antagonist.nl

Please Log in or Create an account to join the conversation.

More
7 years 5 months ago #16 by rstoekenbroek
Replied by rstoekenbroek on topic webtrees very slow after upgrade to 1.7.8
My provider is... Antagonist.NL too!

I'm on PHP7. The I/O limit is set in my hosting package with Antagonist at 10MB/sec.

When I login to WebTrees as administrator, there is NO excessive I/O and delay.
When one logs in to WebTrees as manager, or guest, the I/O problems do occur.

The resource usage graphs show 5-6 seconds of excessive I/O when non-administrators use webtrees.

RobST

Please Log in or Create an account to join the conversation.

  • ToyGuy
  • Offline
  • Moderator
  • Moderator
  • Live like it's Christmas every day - Santa Stephen
More
7 years 5 months ago #17 by ToyGuy
Replied by ToyGuy on topic webtrees very slow after upgrade to 1.7.8
Probably privacy checks

Santa Stephen the Fabled Santa
Latest webtrees at MyArnolds.com
Hosted by webtreesonline.com , a division of GeneHosts LLC
MacOS 10.6.8, Apache 2.2+, PHP 5.4.16, MySQL 5.5.28

Please Log in or Create an account to join the conversation.

More
7 years 5 months ago #18 by fisharebest
Replied by fisharebest on topic webtrees very slow after upgrade to 1.7.8
> Probably privacy checks

It's definitely seems to be related to language. If I visit this page,
I get a very slow response (en-GB).

stamboom.stoekenbroek.com/search.php?ged=stoekenbroek

If I switch to en-US, it becomes very quick.

@rob - what files (names, sizes, dates) do you have in the folder data/cache/

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

More
7 years 5 months ago #19 by rstoekenbroek
Replied by rstoekenbroek on topic webtrees very slow after upgrade to 1.7.8
Greg, the cache directory is completely empty.
That seems wrong, doesn't it?

RobST

Please Log in or Create an account to join the conversation.

More
7 years 5 months ago - 7 years 5 months ago #20 by fisharebest
Replied by fisharebest on topic webtrees very slow after upgrade to 1.7.8
Thanks Rob. I see what is happening, and have submitted a fix.

There was a change in the upgrade wizard in 1.7.6, which you used (in 1.7.7) to upgrade to 1.7.8.

This change was to delete the translation cache, so that updated translations are visible immediately - instead of being updated every hour.

However, the change meant that translation files are now processed for every page.

I've submitted a fix, and will roll out a new release soon.

If you cannot wait, you can simply replace the file app/I18N.php with this new version

raw.githubusercontent.com/fisharebest/we...58ad061/app/I18N.php

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
Last edit: 7 years 5 months ago by fisharebest.

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum
}