Re:Retool Database
by winrid on Thursday March 30, 2023 @08:03PM
(#35380575)
You'll see a performance benefit way before 100k rows depending on the size of each row, especially with sorting. It might save you guys a ton of CPU hosting wise, depending on how this all works, to track slow queries and auto add indexes. Way worth the write overhead in most cases.
[ Parent
| on HN ]
Ah yes if you need sorting then indexed are def the way to go!
Ah yes if you need sorting then indexed are def the way to go!
It’s likely that most of their customers would only have a few hundred or thousand rows where indexing may not actually matter after all. Otherwise I’m sure they would’ve prioritized it.
Yeah for now. You know people will try storing all tweets in it or whatever :)
Re:Retool Database
by johnthescott on Saturday April 01, 2023 @01:20AM
(#35397382)
huh? what about joins? surely your customers are doing joins. a few thousand times a few thousand is >> 1 million.