LumoSQL / archive1-LumoSQL-on-github

Initial work on SQLite and LMDB integration
https://lumosql.github.io/LumoSQL/
Other
68 stars 14 forks source link

Comparison table showing bench marking results #9

Closed maxwell-k closed 4 years ago

maxwell-k commented 4 years ago

1 Is this at all better than unmodified sqlite? a of 2013 and b of 2019?

2 Are the results in line with what Howard said?

3 Are the results interesting?

Is the speed test disk bound? If yes round in tmpfs

danshearer commented 4 years ago

1 Is this at all better than unmodified sqlite? a of 2013 and b of 2019?

Once the compile fix is applied as per https://github.com/LumoSQL/LumoSQL/issues/6 , the cut-down speedtest suite can be run. So far it appears the results are not better than unmodified sqlite.

2 Are the results in line with what Howard said?

No. Not even close. Some runs have produced good numbers, however, when doing a fresh git clone and carefully using the Makefile tool to get the versions correct etc, these good numbers can't be reproduced.

3 Are the results interesting?

Yes. Because this is not expected. More investigation is required.

In addition, it appears unmodified sqlite has improved performance by a factor of nearly 2 in the last six years.

Is the speed test disk bound? If yes round in tmpfs

No it is not. All tests have been tried with tmpfs too.