Re: speed concerns with executemany()

From: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: mike bayer <mike_mp(at)zzzcomputing(dot)com>, Christophe Pettus <xof(at)thebuild(dot)com>, "psycopg(at)postgresql(dot)org" <psycopg(at)postgresql(dot)org>
Subject: Re: speed concerns with executemany()
Date: 2017-01-02 16:07:59
Message-ID: CA+mi_8a-teTQE3kNRmQ5vtPUuxE-d1pwA_2oieAiOb6F0bHw2A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

On Mon, Jan 2, 2017 at 4:35 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
> With NRECS=10000 and page size=100:
>
> aklaver(at)tito:~> python psycopg_executemany.py -p 100
> classic: 427.618795156 sec
> joined: 7.55754685402 sec

Ugh! :D

-- Daniele

In response to

Responses

Browse psycopg by date

  From Date Subject
Next Message Daniele Varrazzo 2017-01-02 16:10:10 Re: speed concerns with executemany()
Previous Message Karsten Hilbert 2017-01-02 15:46:14 Re: speed concerns with executemany()