Re: performance is slow
Tim Roberts <[email protected]>
| Newsgroups | gmane.comp.python.db.psycopg.devel |
|---|---|
| Organization | Providenza & Boekelheide, Inc. |
| Message-ID | <[email protected]> |
Al Niessner wrote: > The main thing that I think I am doing wrong that I want to change is > that I am doing a commit after after insert. I am looking at changing > that to a bigger more "transactional" item. Not sure if this will > improve the overall time, but it seems like a more DB way of doing > things. > That is the key right there. If you change your code so that you do not commit until your whole series of inserts and updates is complete, you'll find that the performance is quite acceptable. -- Tim Roberts, [email protected] Providenza & Boekelheide, Inc.