On Oct 15, 2007, at 5:40 AM, pbienst wrote:
> > Hi, > > I wrote a small program to parse a log file, generate some objects > from it, and then store these objects in an SQL database using the > ORM. > > It takes 20 seconds to parse a 1000 line file. I was wondering if > that's intrinsic in using the high levels of abstraction, or if there > is something that can be done about it, either in my code or in > SQLAlchemy itself. > Ive just committed some inlining optimizations to locate_dirty() in rev 3622. with that revision (which will be in 0.4.0 final), your program appears to run 50% faster with no modifications. though reducing the flush count overall by turning off autoflush=True still remains the better performance optimization. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
