At Manifold I find myself adding indexes for smaller collections. Like, in our postgres db we have a table for mana transactions called txns that has only 1 million rows, and I recently added an index so that a particular query would take 0.6 ms instead of 400ms. This is a query that has to run anytime a user loads their feed, and even if we never100x the size of txns we shouldn’t delay the feed by almost half a second.
At Manifold I find myself adding indexes for smaller collections. Like, in our postgres db we have a table for mana transactions called
txns
that has only 1 million rows, and I recently added an index so that a particular query would take 0.6 ms instead of 400ms. This is a query that has to run anytime a user loads their feed, and even if we never100x the size oftxns
we shouldn’t delay the feed by almost half a second.(I am generally for rapid, hacky prototyping)