Parallel insert to postgresql with thread

Jean-Paul Calderone exarkun at divmod.com
Thu Oct 25 07:31:45 EDT 2007


On Thu, 25 Oct 2007 04:00:44 -0700, Abandoned <besturk at gmail.com> wrote:
>Hi..
>I use the threading module for the fast operation.

For fast operation, avoid the threading module.  Here's a code sample:

    conn = connect(...)
    cursor = conn.cursor()
    cursor.executemany("INSERT INTO keywords (keyword) VALUES (%s)", datas)

Note that I also corrected your use of %, which was unnecessarily complex and
insecure.

Jean-Paul



More information about the Python-list mailing list