Database update performance was great!

Meta
1

Just passing by to thank the whole team responsible for the database update this month.

I’m not entirely sure on when this change was finished, but I just noticed that the function of copying the live database to dev database is absurdly faster!

TLDR: We’re just short of 1M records on a table (around 110k users), and that function took about 9 hours the last time I used it (and we had fewer records). Today, I triggered on a browser tab and forgot about it, thinking it should be done sometime around Monday morning. I just realized it was already complete! It was done within minutes!

Anyways, again, just appreciating the input among so many critics (including mine). Thanks again, very nice job!

8 Likes
2

good to hear, i wonder what other improvements we have

3

@fede.bubble

4

I see 600ms-400 ms performance increase on load (especially on fcp), and better cache, is this true also ? or placebo ?

5

Performance improved a lot, creating new things in db is faster now, almost instant.

1 Like
6

I got excited and started a full db live to dev copy last night, sadly it is still going and probably won’t be done until about 24 hours, which has been the norm over the past several months.

When was the last time you did a copy where it was different than now? My guess is that maybe with a single data type there could be some improvements, but with a full db copy it still takes way too long compared to traditional solutions.