4 ms·
SQL db as cache – 2x faster* requests vs. Redis
- fbdab103 3y ago>Since we added Solid Cache to Basecamp, the 95 percentile request duration fell from 375ms to 225ms. There’s no magic here, just the effect of a bigger cache! A few more numbers to understand the load characteristics would be helpful, but that top line number is pretty impressive.
- jbverschoor 3y agoMainly fragment cache, so cached HTML parts. It wouldn't make sense for caching simple objects (for example caching a query-record-by-id)
- fiedzia 3y ago>It wouldn't make sense for caching simple objects (for example caching a query-record-by-id) Yes, caching database queries in a database would be a groundbreaking technology
- hiyer 3y agoReally love how the 37signals guys are turning conventional wisdom on its head - moving from cloud back to own data center, getting rid of SPAs with Hotwire, and now this. More power to DHH and co.
- hiyer 3y agoAnd just to add - they've never taken VC funding; and they've been remote from the get-go before it was a thing. Truly a unique organization. Note - I don't work there or use any of their products (other than Ruby on Rails). These are just my honest observations.
- frankjr 3y ago> they've never taken VC funding They have taken investment from Jeff Bezos decades ago. https://archive.ph/3v3QS https://archive.ph/3v3QS
- dejv 3y agoTechnically it was not an investment, they've sold part of company to Bezos. As in money went directly into owners bank accounts instead of bank account of the company.
- frankjr 3y agoYou're right, TIL. https://medium.com/signal-v-noise/the-deal-jeff-bezos-got-on-basecamp-b7a1cb39179e https://medium.com/signal-v-noise/the-deal-jeff-bezos-got-on...
- 0xblinq 3y agoI agree. I understand DHH pisses off many people when he speaks, and some times he could probably be a bit less harsh, but I admire him a lot because he's one of the few people I know in this industry critically thinking, applying common sense, and not blindly following fads and all the bullshit that's going on at most places. I think overall it is a net gain to follow and listen what he says, even if not said in the most "nice" way, I agree on almost everything he says tech wise. And using Rails after years of pure "modern" SPAs, feels really refreshing. I'm sad most of us have forgotten how simpler things could be, and terrified about new people joining the industry that will never know it (for the time being at least).
- gregjor 3y agoThe software business constantly rediscovers old technologies and techniques, renames them, and calls it innovation.
- Dachande663 3y agoAre the response times from a client point of view? If they’re internal, is 225-375 standard for this kind of stack?
- andrejguran 3y agowonder what would happen if they'd add a bigger Redis cache
- Lio 3y agoWell I doubt you could beat Redis for pure performance but bigger Redis cache would likely cost more to run. So the real question is about cost/performance and picking the one that best fits your use case. I also wonder how tweaking the backing DB's in memory cache will effect things. Either way it's great to get this stuff out of the box with Rails and then be able to swap for Redis later if you observe that being a better fit.