Re: Performance problems due to incorrect many-many primary key on many tables

2012-12-07 Thread James Pic
This might also work: https://github.com/simone/django-compositekey#customize-the-manytomany-intermediate-modeltable On Fri, Dec 7, 2012 at 10:51 AM, James Pic wrote: > I'm not sbure but I think you can make an external app that overrides > syncdb and creates optimised many to many tables befor

Re: Performance problems due to incorrect many-many primary key on many tables

2012-12-07 Thread James Pic
I'm not sbure but I think you can make an external app that overrides syncdb and creates optimised many to many tables before handing the job django's syncdb. If the tables exist, django won't create them. On Wed, Nov 28, 2012 at 9:56 PM, Anssi Kääriäinen wrote: > On 27 marras, 21:11, Trey Raymo

Re: Performance problems due to incorrect many-many primary key on many tables

2012-11-28 Thread Anssi Kääriäinen
On 27 marras, 21:11, Trey Raymond wrote: > Hi folks, > I'm a DB engineer working for Yahoo, and we have a new product using django > that I'm onboarding.  We see a variety of easily fixed issues, but one > major one - there are 21 many-many tables here, yet they have auto > increment primary keys.

Performance problems due to incorrect many-many primary key on many tables

2012-11-28 Thread Trey Raymond
Hi folks, I'm a DB engineer working for Yahoo, and we have a new product using django that I'm onboarding. We see a variety of easily fixed issues, but one major one - there are 21 many-many tables here, yet they have auto increment primary keys. This of course is very slow on any platform, bu