4 ms·

How big is your database? Why are you not keeping it in memory? Was this an actual, real bottleneck? How many servers do you currently rent?

• jedicoffee 14y ago
  Preach!
• benmccann 14y ago
  SSDs are cheaper than RAM. I'm not keeping a 1TB database in memory.
  • CCs 14y ago
    How about SAP HANA? They keep 100TB in memory... They have startup program: http://www.saphana.com/community/learn/startups http://www.saphana.com/community/learn/startups
    • taligent 14y ago
      I've used SAP HANA and it's a fantastic piece of software arguably the best SQL database on the market today. It also costs an absolute fortune (only approved hardware allowed) and even the AWS instance which costs $3.50/hour is not certified for production deployments. I don't know many startups who can afford $5000 a month for minimum redundancy.
• deleted 14y ago
  [deleted]
• isalmon 14y ago
  That's not an option for me, my database is more than 20G.
  • rorrr 14y ago
    32GB of RAM is $220 on Newegg.
    • deleted 14y ago
      [deleted]
    • ericd 14y ago
      Or, http://www.ovh.com/ca/en/dedicated-servers/ http://www.ovh.com/ca/en/dedicated-servers/
• rorrr 14y ago
  DB in RAM still requires to write to disk, which is often the bottleneck, not the reads.