SQLObject Performance Guide
John has written a useful SQLObject Performance Guide which I’ve just used to optimise ShowMeDo’s database usage.
SQLObject was the default for TurboGears when we started. Understanding what goes on under the hood is essential to making it perform well.
John uses examples to discuss:
- Query logging (debug=True)
- SQLRelatedJoin vs RelatedJoin (and MultipleJoins)
- Lazy vs ‘normal’ db access