News for hackers. Stuff that matters.
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.
Re:Retool Database by sikan on Thursday March 30, 2023 @08:12PM (#35380625)
Ah yes if you need sorting then indexed are def the way to go!
Re:Retool Database by sikan_ on Thursday March 30, 2023 @09:39PM (#35381302)
Ah yes if you need sorting then indexed are def the way to go!
Re:Retool Database by atonse on Thursday March 30, 2023 @09:54PM (#35381409)
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.
Re:Retool Database by winrid on Friday March 31, 2023 @02:13AM (#35383292)
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.