SQL queries improvement - Githubissues

Farfetch / kafkaflow-retry-extensions

Kafka Flow Retry Patterns Extensions

https://farfetch.github.io/kafkaflow-retry-extensions/

MIT License

55 stars 7 forks source link

SQL queries improvement #80

Open fernando-a-marins opened 2 years ago

fernando-a-marins commented 2 years ago

Is your request related to a problem you have?

The queries in the SQL repositories (SQL Server & Postgres) might be improved, avoiding some behaviors like:

Using the operator in in the queries for IDs, will force new execution plans, every time.
Perform select *, only use the fields that are really necessary.
Dynamically declared parameter sizes (e.g. dynamically declaring the size of the QueueGroupKey) - original issue: #23

Describe the solution you'd like

No response

Are you able to help bring it to life and contribute with a Pull Request?

Yes

Additional context

No response