RE: Complex query reduction

2013-11-03 Thread Robin St . Clair
Hi You are running into typical production Django problems - works fine in testing, terrible in production. Firstly If you use attributed many-to-manys, create the table outside of Django and use raw SQL.Create a primary key on the two things being related (usually larger table first). Multi-colu

Re: Complex query reduction

2013-11-07 Thread Robin St . Clair
Anssi The last time I checked the use of IN, all the records from the database in the query were brought back to the workstation, rather than being processed on the backend and only the results returned to the workstation. Have there been changes that carry out the entire query on the backend