fast-sqlite3-inserts
fast-sqlite3-inserts copied to clipboard
avinassh
Some bunch of test scripts to generate a SQLite DB with 1B rows in fastest possible way
I might be missing something here as I'm still new to async in rust, but as I understand it calling await on a future forces the runtime to serialize the...
Based from #11. This PR adds a new method of quickly inserting 100M rows into a SQLite table, using a pure SQLite approach. Using the [`generate_series`](https://www.sqlite.org/series.html) table valued function, we...
What about a using SQLite for test data generation? ## Example: ```sql CREATE TABLE test ( id INTEGER PRIMARY KEY NOT NULL, x REAL NOT NULL, y REAL NOT NULL,...
Fix #10 Unsafe is probably not nice but I am not sure how to satisfy borrow checker there. I tried using `mem::swap` and related functions but it still seemed like...
This PR enables binaries who uses `rusqlite` to statically linked with `libsqlite3.a` compiled with LTO using linker-plugin-lto. To compile these binaries (excluding `basic_async.rs`), just run `make -j $(nproc)`. It will...
Rather than creating the Vec in the inner loop, you can create it in the outer loop using with_capacity with capacity of batch size so it will not allocate in...