You are viewing a single comment's thread.

view the rest of the comments →

neogag ago

  • What kind of product licensing? Please tell me you aren't paying for Microsoft SQL Server. Replace all those licensed products with open source equivalents.

  • Maybe silly suggestion, as I haven't seen your codebase: benchmark and optimize so you can use cheaper hardware to host this thing.

PuttItOut ago

The code has just recently gotten to a place where we can optimize it. It is on our list but we need staff, it's simply too much for me to continue doing alone. So, if funding does happen, this will be one of the first things done.

We have been working our data access code to be able to port to pg, but to answer your question, sql is not a significant cost for us right now. This will not always be the case.

neogag ago

  • Again, maybe a silly suggestion: you could also go for auto-scaling hosting. AWS has that, it's not too hard to setup and will scale down hardware automatically depending on the amount of traffic you get

  • Use Async everywhere to serve more requests while IO operations are happening

  • What kind of staff/contributors are needed? Maybe we could get people from v/programming to help out. My spare time is very fragmented, is there a way to contribute for someone who has numerous small irregular blocks of time?

  • edit: Also ditch Comodo SSL certificate, Let's Encrypt is free and easy as hell to set up!

edit2:

  • Double cache duration on up/downvoats

  • Enable HTTP2, it multiplexes frequent requests using a persistent connection

RiverWind ago

AWS could be a stop-gap. If desperate, they have an options where you can choose processing as it becomes available, but not on a guaranteed basis.