a thoughtful web.
Good ideas and conversation. No ads, no tracking.   Login or Take a Tour!
comment by bioemerl
bioemerl  ·  2737 days ago  ·  link  ·    ·  parent  ·  post: Hubski Update: SQL migration complete

Will this reduce site costs?





rob05c  ·  2737 days ago  ·  link  ·  

The big site cost is paying for memory, because we currently load everything into memory. The SQL database doesn't directly fix that, but it makes it possible to load data as-needed. Once we actually do that, we'll be able to pay for hosting with less memory.

It's not quite as easy as it sounds. Changing a data field to load from SQL where it's needed is easy. The problem is, the code currently assumes data is cheap, and will do things like load that field for every post ever, just to get it for a single post. That has to be fixed. But we'll get there.

bioemerl  ·  2737 days ago  ·  link  ·  
This comment has been deleted.
mk  ·  2737 days ago  ·  link  ·  

Yes, it should. We are going to start testing that soon.