Created
February 16, 2014 04:55
-
-
Save danpoltawski/9029458 to your computer and use it in GitHub Desktop.
time to switch to mongodb?
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| danp@bart:~$ time psql shouldirun -c "SELECT COUNT(DISTINCT(identifierforvendor)) FROM request_info" | |
| count | |
| ------- | |
| 45543 | |
| (1 row) | |
| real 0m6.880s | |
| user 0m0.003s | |
| sys 0m0.003s | |
| danp@bart:~$ time mongo --quiet shouldirun --eval "printjson(db.request_info.distinct('identifierforvendor').length)" | |
| 45543 | |
| real 0m0.700s | |
| user 0m0.031s | |
| sys 0m0.011s |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment