The database design you have is less than perfect. The goal of having to reformat the relational DB into a CSV is less than perfect.
If I were you, I would think about 3 questions: 1. How often do you have to run this? 2. Does it take too long? 3. Does it use up too much DB/Python memory? If this isn't a resource issue, and a 1x a day task... don't worry about it. Let the non-optimal code run. If you need to run this every 5 minutes, then I'd start to worry. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
