Don't plan twice for prepared statements
Open
performance
- Dominant language
- C++
- Stars
- 3.2k
- Forks
- 204
- PR merge metrics
- No merged PRs in 30d
Description
In #147 we added support for prepared statements, but that was done planning the query twice in DuckDB, once during planning to get the the column types of the result and once during execution. While this works, it's clearly suboptimal performance wise, and it's something we should change eventually.
Contributor guide
Research direction
Start by reading issue #147 to understand the existing prepared-statement support, then trace how DuckDB planning is used first to obtain result column types and again during execution. Done means prepared statements no longer plan the query twice while preserving the existing behavior.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- cpp, postgres
- Domain
- backend, databases
- Issue type
- Refactor
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 30/100