Aw: Re: psycopg3, prepared statements

Поиск
Список
Период
Сортировка
От Karsten Hilbert
Тема Aw: Re: psycopg3, prepared statements
Дата
Msg-id trinity-0fb2c7c8-9eec-4aa3-b943-4cdfea6e2525-1608629485973@3c-app-gmx-bs15
обсуждение исходный текст
Ответ на Re: psycopg3, prepared statements  (Vladimir Ryabtsev <greatvovan@gmail.com>)
Список psycopg
 
>> - if more than `connection.prepared_number` queries are prepared, the> one
>> used least recently is deallocated and evicted from the cache
>> (proposed default: 100).
 
>Why do you need such logic? Why not just keep some limited number of
>prepared statements? Is it a problem if a PS is in cache but rarely used?

On resource constrained environments one wants to be
able to balance use vs disuse.

Here I agree with Adrian: automagic, yes but only if one can
opt out by default.

Karsten
 



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

Предыдущее
От: Vladimir Ryabtsev
Дата:
Сообщение: Re: psycopg3, prepared statements
Следующее
От: Daniele Varrazzo
Дата:
Сообщение: Re: psycopg3, prepared statements