Ancestors

Toot

Written by Ellie Huxtable on 2025-01-22 at 15:29

"just get a bigger server”

=> View attached media

=> More informations about this toot | More toots from ellie@hachyderm.io

Descendants

Written by EndlessMason on 2025-01-22 at 15:34

@ellie Just a little more RAM, i swear it'll work this time

=> More informations about this toot | More toots from EndlessMason@hachyderm.io

Written by Ellie Huxtable on 2025-01-22 at 15:34

@EndlessMason if the entire dataset sits in memory then the worst queries don't look bad any more 😌

=> More informations about this toot | More toots from ellie@hachyderm.io

Written by Le Chep on 2025-01-22 at 15:47

@ellie @EndlessMason and then Product requires that any search in that multicriteria form returns in under 2 seconds even if it has to trawl through a half billion × quarter billion row join, no you can't materialize, and suddenly that sweet terabyte of RAM is gone 🤣

=> More informations about this toot | More toots from c_chep@piaille.fr

Written by EndlessMason on 2025-01-22 at 15:49

@c_chep @ellie If full database searches were supposed to be that fast we'd have a better schema

=> More informations about this toot | More toots from EndlessMason@hachyderm.io