Hey guys, I'm Amir - Founder of Toutpost. We're a YCombinator 2013 company.
We're growing very fast but are having performance issues. We have never scaled an application on SQLAlchemy before so we think that our usage of relationships is suboptimal. It's preventing us from implementing a decent caching strategy as well. Technical overview is below my sig. We're all engineers, we built the stack ourselves. You wouldn't be working with non-technical people - just coders working with coders (Two ex-Zynga CTOs running the company). We're looking for help on an immediate basis and can pay fairly well. We really need someone who is available immediately. If interested please e-mail me: a...@toutpost.com Thanks! Amir Elaguizy Founder of Toutpost a...@toutpost.com *Technical overview of the issue:* We're paying massive costs in CPU time building the models, even though our actual time in pgsql is not significant. We've tried out the dogpile caching strategy but because of the number of relationships and polymorphic models in use - caching a single model or relationship doesn't give solid gains. The biggest gains we were able to get were when we pickle'd the entire objects to memcache, but then we have a problem of not being able to use relationships due to them being detached from the session when deserializing from memcache. But in order to get those relationships into memcache, we would essentially have to joinedload in every relationship on the model - which is prohibitively expensive. So we'd like someone who can optimize our usage of SQLAlchemy, which probably means working on our schema some. Then we'd like them to implement a caching strategy as well. The goal would be to have surprisingly fast page loads, right now we're seeing about 1 request/second locally, less on heroku. We'd like to be able to handle 5-8 requests per second per worker thread in order to have a seriously performant site. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.
