vsql icon indicating copy to clipboard operation
vsql copied to clipboard

Add benchmarks with other drivers (sqlite, pg)

Open Terisback opened this issue 2 years ago • 4 comments

It would be useful to have a table with driver comparisons

Terisback avatar Sep 22 '21 09:09 Terisback

@Terisback do you feel like updating adding some makefile targets for bench-sqlite and bench-pg?

elliotchance avatar Sep 23 '21 06:09 elliotchance

As soon as I find time, I'll do it.

Terisback avatar Sep 28 '21 07:09 Terisback

On second thought, maybe just add the sqlite comparison as that's more apples to apples. Even though vsql can run as a postgresql server it's still a file on disk underneath and isn't used like a postgresql server would.

elliotchance avatar Sep 28 '21 13:09 elliotchance

I think both (sqlite & pg) would be useful despite each showing something different. A concurrency setup (i.e. on a machine with at least 4 CPUs/cores and an SSD disk) together with 100+ concurrent client connections would be best.

dumblob avatar Dec 22 '21 11:12 dumblob