README.md in csvsql-0.1.1 vs README.md in csvsql-0.1.2

- old
+ new

@@ -88,14 +88,69 @@ ``` csvsql --clear-cache ``` -## Performance TODO +## Performance (MBP 2016) -* 10,000 lines -* 10,000 lines with cache +**Data** + +``` +title,desc,created_at:datetime +1asdfklajskdjfk alksd flka sdfkja sldfk ,lka sdfa sdlkfj alkr jl2kjlkajslkdfjak,2017-10-20 20:20 + +``` + +**10,000 lines** + +``` +$ time csvsql -i /tmp/a.csv "select count(*) from csv" +``` + +output + +``` +count(*) +100000 + +real 0m5.070s +user 0m4.776s +sys 0m0.256s +``` + +**10,000 lines with cache** + +``` +$ time csvsql -c -i /tmp/a.csv "select count(*) from csv" +``` + +Output + +``` +count(*) +100000 + +real 0m4.677s +user 0m4.309s +sys 0m0.253s +``` + +Second output + +``` +$ time csvsql -c -i /tmp/a.csv "select count(*) from csv" +``` + +``` +count(*) +100000 + +real 0m0.502s +user 0m0.327s +sys 0m0.151s +``` + * 1,000,000 lines * 1,000,000 lines with cache ## Development @@ -108,5 +163,6 @@ Bug reports and pull requests are welcome on GitHub at https://github.com/[USERNAME]/csvsql. ## License The gem is available as open source under the terms of the [MIT License](https://opensource.org/licenses/MIT). +/