1500x speed-up on family tree homepage

jasonrohrer · 2018-07-19 15:43:59

Whoops... turns out that there was no MySQL index in place for some of the columns that were being used to sort lives on the front page.

There are six lists on the front page, and I clocked one of the lists (the all time long lines) as taking 1.2 seconds to generate.

With the new index in place, it now takes 0.00079350 seconds to generate. a 1500x speed-up.

Family tree home page is fast again.

This issue became more and more noticeable as more lives were added. We have 620,939 lives in the family tree system as of today.

Those lives are taking up 127 MiB. That's 204 bytes per life, on average. There are 16 GiB free on the lineage server, which means we can expect to store 82 million lives before running out of space there. At the current life rate, that's 17 years. But I do anticipate that the life rate will grow over time.

At some point, I will have to implement some kind of culling of ancient lives.

http://lineage.onehouronelife.com/serve … front_page

YAHG · 2018-07-19 15:52:05

jasonrohrer wrote:

it now takes 0.00079350 seconds to generate.

No one has that kind of time..

Turnipseed · 2018-07-19 17:18:01

YAHG wrote:

jasonrohrer wrote:
it now takes 0.00079350 seconds to generate.
No one has that kind of time..

Dont you mean "aint no body got time fo dat"?

YAHG · 2018-07-19 17:19:29

Turnipseed wrote:

YAHG wrote:
jasonrohrer wrote:
it now takes 0.00079350 seconds to generate.
No one has that kind of time..
Dont you mean "aint no body got time fo dat"?

Yeah that would've been better </3..

One Hour One Life Forums

#1 2018-07-19 15:43:59

1500x speed-up on family tree homepage

#2 2018-07-19 15:52:05

Re: 1500x speed-up on family tree homepage

#3 2018-07-19 17:18:01

Re: 1500x speed-up on family tree homepage

#4 2018-07-19 17:19:29

Re: 1500x speed-up on family tree homepage

Board footer