[BangPypers] Scaling Django-Mysql

[Deepak Thukral]

> Just checking to see if anyone on this list has experience
> scaling a django
> app using mysql as the backend. I have many issues - eg.
> one involves
> constructing Qsets with icontain statements for a table
> with 50000 records.

Its limitation of Django ORM, You can cache result, don't use Generic FK, Q is quite flexible but you can call SQL statement and wrap then into sqlobject.

Alternatively, have a look on SQLAlchemey and PostgreSQL uses MVCC for transaction resolution and its much better than MySQL

Cheers,
Deepak