Re: exporting related data without killing the db

2007-11-27 Thread lispingng
Thanks, actually i have been baulking a little cos i have not yet studied writing custom sql in django. I'll get on with it and check on you with more specific issues as they appear. On Nov 26, 12:13 pm, jj <[EMAIL PROTECTED]> wrote: > I solved a similar issue using custom SQL. It's a little tedi

Re: exporting related data without killing the db

2007-11-26 Thread jj
I solved a similar issue using custom SQL. It's a little tedious to write, but the boost is significant. The way I've structured this: 1. create a manager for the main class 2. for each related object (either foreignKey or many2many), create a method fieldname_in_bulk() 3. create a method select_

exporting related data without killing the db

2007-11-26 Thread lispingng
Hi, I am working on a large project that requires i export applications to csv. the problem is the Application model has about six foreignkey fields including one to the Profiles model. also there are two backward relations to the Application models as well in other words the model structure is a