elixir-sqlite / exqlite

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

Benchmark multi_step vs step implementation #217

Closed warmwaffles closed 1 month ago

warmwaffles commented 1 year ago

Originally I implemented the adapter to use single steps and just let it work with erlang's scheduler. I remember I ran into issues where selecting data was actually slower than just batching the results in a list and returning them.

What I would like to do is add a benchee test that works with both methods on a large data set, to really see what sort of improvements can be made and can be quantified.

If we can just utilize step alone and let the scheduler work, that would simplify the NIF code.