|
|
|
| go ahead... be a heretic | |
| PerlMonks |
Re^8: Best practices for closing database connections?by erix (Prior) |
| on Jun 16, 2022 at 09:56 UTC ( #11144794=note: print w/replies, xml ) | Need Help?? |
|
For placeholders, here's my take. You may not spot a difference with a single query if processing time is less than a millisecond but when repeated, you do notice. On one local postgres server (version 15 beta 1), when I compare queries with placeholder versus hard-coded, the placeholder variant is consistently 2 to 3 times faster. (I think the main reason must be that the PREPARE needs only to run once.)
In Section
Seekers of Perl Wisdom
|
|
||||||||||||||||||||||||