Tag Archives: optimization

Optimizing Django ORM / Postgres queries using left join

For the latest project I’m working on, we’re using Django with Postgres. I was writing some code that had to find a list of objects that weren’t processed yet. The way they were stored in the DB is like so: … Continue reading

Posted in Databases, Optimization | Tagged , , , , , | 1 Comment

Pyweb-il Presentation on Optimization Slides

Last Monday I gave a presentation in pywebil on optimization, that’s loosely based on my blog post on the same subject. Here are the slides for that presentation.

Posted in Optimization, Programming, Python | Tagged , , , | Leave a comment

Javascript Element Creator

Some time ago I was working on optimizing the client side code of my website, plnnr.com, an online trip planner. This website does automatic trip planning, and the problem was that recalculating trips was slow. After profiling, I found out … Continue reading

Posted in Javascript, Optimization, Programming, Projects, startup, web-design | Tagged , , , | 2 Comments

10 Python Optimization Tips and Issues

Following my previous post on Optimizing Javascript, I thought I’d write a similar post regarding Python optimization.

Posted in computer science, Design, Optimization, Programming, Python | Tagged , , , , | 7 Comments

Javascript Optimization Tricks

Profiling, Profiling, Profiling This seems obvious, but still merits a mention. Don’t optimize your code before profiling it. If you need a profiler, just use firebug’s. Having tests to make sure that your post-profiling code is equivalent to the original … Continue reading

Posted in Javascript, Optimization | Tagged , , , , | 2 Comments

PNG Minification

Following Ned Batchelder’s advice I’ve used pngout to minify the png’s on my startup’s web page. It took them down from 641,281 bytes to 338,705. This is quite a nice return for the effort of a download and a single … Continue reading

Posted in web-design | Tagged , , | 4 Comments