Re: [psycopg] speed concerns with executemany()

Поиск
Список
Период
Сортировка
От Daniele Varrazzo
Тема Re: [psycopg] speed concerns with executemany()
Дата
Msg-id CA+mi_8bMRz5GLXM2=N0dsdrquBthn5He2LgAqor-dWvGS6mqAg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [psycopg] speed concerns with executemany()  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: [psycopg] speed concerns with executemany()  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список psycopg
On Sat, Dec 24, 2016 at 2:05 AM, Adrian Klaver
<adrian.klaver@aklaver.com> wrote:

> I have to go with Christophe's explanation. They are seeing the effects of
> 200 separate transactions, though like he stated later this more an
> assumption then something I have tested.

My wild wild wild assumption is that they have a trigger on the table
that gets triggered 200 times instead of one.

The only thing I am sure of is that psycopg doesn't use any BEGIN
specifically in executemany.


-- Daniele


В списке psycopg по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [psycopg] speed concerns with executemany()
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: [psycopg] speed concerns with executemany()