elixir-sqlite / exqlite

An SQLite3 driver for Elixir
https://hexdocs.pm/exqlite
MIT License
217 stars 48 forks source link

Reset stmt when done #305

Closed ruslandoga closed 1 month ago

ruslandoga commented 1 month ago

Handles https://github.com/elixir-sqlite/exqlite/pull/298#discussion_r1792822558

[...] In the future, it should be called once we are done with the statement rather than before using it since otherwise SQLite would be wasting resources by keeping finished but non-reset statements.

It also improves bind/2 performance since it doesn't have to go through dirty scheduler for a reset/1 call anymore.