Support for Prepared Statements?

[kevinelliott]

Would it be possible to add support for prepared statements? This has the potential to improve performance with PostgreSQL quite significantly for apps that have significant load.

[dukefirehawk]

I don't think ORM is using prepared statement at the moment. Agree that prepared statement can improve the performance. Will take a closer took at the query generator to find a way to support it along with the other changes and fixes to the ORM.

[kevinelliott]

That would be amazing, thanks @dukefirehawk !

[kevinelliott]

Now that the push to support dart 3.6 is done, what do you think about adding the support for Postgres prepared statements? This would be amazing.

[dukefirehawk]

Prepare statement and transaction will be getting the attention soon as part of the overall performance review since issues related to MySQL and code generation have been resolved.