[winrid]

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.

[atonse]

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.

[winrid]

Yeah for now. You know people will try storing all tweets in it or whatever :)

[johnthescott]

huh? what about joins? surely your customers are doing joins. a few thousand times a few thousand is >> 1 million.

[sikan_]

Ah yes if you need sorting then indexed are def the way to go!