Skip to content

Instantly share code, notes, and snippets.

@loclamor

loclamor/time compare

Created August 1, 2013 08:40
Show Gist options
  • Save loclamor/6129600 to your computer and use it in GitHub Desktop.
Save loclamor/6129600 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
time compare
Search on -4.8,41.5,9.2,51 from 2012-01-01T00:00:00.000Z to 2012-12-31T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 17618 2740 20358 100/922
Syracuse 2 16778 0 16778 100/922
Syracuse 3 16980 0 16980 100/922
Syracuse 4 17043 0 17043 100/922
MongoDBSyracuse 1 21251 9750 31001 100/922
MongoDBSyracuse 2 15383 0 15383 100/922
MongoDBSyracuse 3 15208 0 15208 100/922
MongoDBSyracuse 4 15205 0 15205 100/922
Search on -4.8,41.5,9.2,51 from 1995-05-01T00:00:00.000Z to 1995-08-01T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 1023 36 1059 100/322
Syracuse 2 57 0 57 100/322
Syracuse 3 69 0 69 100/322
Syracuse 4 68 0 68 22/322
MongoDBSyracuse 1 5710 5596 11306 100/322
MongoDBSyracuse 2 5823 0 5823 100/322
MongoDBSyracuse 3 5680 0 5680 100/322
MongoDBSyracuse 4 5676 0 5676 22/322
Search on -4.8,41.5,9.2,51 from 2000-08-01T00:00:00.000Z to 2001-02-01T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 2779 101 2880 100/1072
Syracuse 2 139 0 139 100/1072
Syracuse 3 161 0 161 100/1072
Syracuse 4 180 0 180 100/1072
MongoDBSyracuse 1 5796 5557 11353 100/1072
MongoDBSyracuse 2 5815 0 5815 100/1072
MongoDBSyracuse 3 5806 0 5806 100/1072
MongoDBSyracuse 4 5810 0 5810 100/1072
Search on -4.8,41.5,9.2,51 from 1980-09-01T00:00:00.000Z to 1980-09-08T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 352 4 356 33/33
Syracuse 2 5 0 5 0/33
Syracuse 3 4 0 4 0/33
Syracuse 4 4 0 4 0/33
MongoDBSyracuse 1 5741 5622 11363 33/33
MongoDBSyracuse 2 5826 0 5826 0/33
MongoDBSyracuse 3 5840 0 5840 0/33
MongoDBSyracuse 4 5781 0 5781 0/33
Search on -1.1,42.5,2.4,45 from 2012-01-01T00:00:00.000Z to 2012-12-31T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 1726 910 2636 34/34
Syracuse 2 1727 0 1727 0/34
Syracuse 3 1724 0 1724 0/34
Syracuse 4 1727 0 1727 0/34
MongoDBSyracuse 1 8922 8183 17105 34/34
MongoDBSyracuse 2 8827 0 8827 0/34
MongoDBSyracuse 3 8834 0 8834 0/34
MongoDBSyracuse 4 8832 0 8832 0/34
Search on -1.1,42.5,2.4,45 from 1995-05-01T00:00:00.000Z to 1995-08-01T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 27 14 41 20/20
Syracuse 2 18 0 18 0/20
Syracuse 3 19 0 19 0/20
Syracuse 4 18 0 18 0/20
MongoDBSyracuse 1 5798 5476 11274 20/20
MongoDBSyracuse 2 5601 0 5601 0/20
MongoDBSyracuse 3 5597 0 5597 0/20
MongoDBSyracuse 4 5598 0 5598 0/20
Search on -1.1,42.5,2.4,45 from 2000-08-01T00:00:00.000Z to 2001-02-01T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 101 52 153 65/65
Syracuse 2 100 0 100 0/65
Syracuse 3 102 0 102 0/65
Syracuse 4 103 0 103 0/65
MongoDBSyracuse 1 5620 5477 11097 65/65
MongoDBSyracuse 2 5613 0 5613 0/65
MongoDBSyracuse 3 5615 0 5615 0/65
MongoDBSyracuse 4 5614 0 5614 0/65
Search on -1.1,42.5,2.4,45 from 1980-09-01T00:00:00.000Z to 1980-09-08T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 3 1 4 2/2
Syracuse 2 2 0 2 0/2
Syracuse 3 2 0 2 0/2
Syracuse 4 2 0 2 0/2
MongoDBSyracuse 1 5696 5634 11330 2/2
MongoDBSyracuse 2 5801 0 5801 0/2
MongoDBSyracuse 3 5698 0 5698 0/2
MongoDBSyracuse 4 5700 0 5700 0/2
Search on -5.8,45.8,1.2,50.6 from 2012-01-01T00:00:00.000Z to 2012-12-31T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 4260 1426 5686 100/179
Syracuse 2 4284 0 4284 79/179
Syracuse 3 4289 0 4289 0/179
Syracuse 4 4323 0 4323 0/179
MongoDBSyracuse 1 10163 8372 18535 100/179
MongoDBSyracuse 2 10141 0 10141 79/179
MongoDBSyracuse 3 10374 0 10374 0/179
MongoDBSyracuse 4 10140 0 10140 0/179
Search on -5.8,45.8,1.2,50.6 from 1995-05-01T00:00:00.000Z to 1995-08-01T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 44 27 71 46/46
Syracuse 2 34 0 34 0/46
Syracuse 3 34 0 34 0/46
Syracuse 4 35 0 35 0/46
MongoDBSyracuse 1 5601 5474 11075 45/45
MongoDBSyracuse 2 5599 0 5599 0/45
MongoDBSyracuse 3 5596 0 5596 0/45
MongoDBSyracuse 4 5605 0 5605 0/45
Search on -5.8,45.8,1.2,50.6 from 2000-08-01T00:00:00.000Z to 2001-02-01T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 114 70 184 100/219
Syracuse 2 136 0 136 100/219
Syracuse 3 142 0 142 19/219
Syracuse 4 141 0 141 0/219
MongoDBSyracuse 1 5647 5477 11124 100/219
MongoDBSyracuse 2 5642 0 5642 100/219
MongoDBSyracuse 3 5829 0 5829 19/219
MongoDBSyracuse 4 5649 0 5649 0/219
Search on -5.8,45.8,1.2,50.6 from 1980-09-01T00:00:00.000Z to 1980-09-08T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 3 2 5 5/5
Syracuse 2 2 0 2 0/5
Syracuse 3 3 0 3 0/5
Syracuse 4 2 0 2 0/5
MongoDBSyracuse 1 5701 5557 11258 5/5
MongoDBSyracuse 2 5700 0 5700 0/5
MongoDBSyracuse 3 5694 0 5694 0/5
MongoDBSyracuse 4 5699 0 5699 0/5
Search on 1,46,8,51 from 2012-01-01T00:00:00.000Z to 2012-12-31T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 8454 1534 9988 100/416
Syracuse 2 8479 0 8479 100/416
Syracuse 3 8626 0 8626 100/416
Syracuse 4 8812 0 8812 100/416
MongoDBSyracuse 1 11938 8798 20736 100/416
MongoDBSyracuse 2 11914 0 11914 100/416
MongoDBSyracuse 3 11844 0 11844 100/416
MongoDBSyracuse 4 11907 0 11907 100/416
Search on 1,46,8,51 from 1995-05-01T00:00:00.000Z to 1995-08-01T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 39 17 56 100/125
Syracuse 2 33 0 33 25/125
Syracuse 3 32 0 32 0/125
Syracuse 4 32 0 32 0/125
MongoDBSyracuse 1 5772 5486 11258 100/125
MongoDBSyracuse 2 5593 0 5593 25/125
MongoDBSyracuse 3 5585 0 5585 0/125
MongoDBSyracuse 4 5592 0 5592 0/125
Search on 1,46,8,51 from 2000-08-01T00:00:00.000Z to 2001-02-01T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 99 59 158 100/458
Syracuse 2 127 0 127 100/458
Syracuse 3 151 0 151 100/458
Syracuse 4 180 0 180 100/458
MongoDBSyracuse 1 5661 5497 11158 100/458
MongoDBSyracuse 2 5669 0 5669 100/458
MongoDBSyracuse 3 5651 0 5651 100/458
MongoDBSyracuse 4 5655 0 5655 100/458
Search on 1,46,8,51 from 1980-09-01T00:00:00.000Z to 1980-09-08T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 4 2 6 16/16
Syracuse 2 3 0 3 0/16
Syracuse 3 3 0 3 0/16
Syracuse 4 3 0 3 0/16
MongoDBSyracuse 1 5675 5633 11308 16/16
MongoDBSyracuse 2 5764 0 5764 0/16
MongoDBSyracuse 3 5671 0 5671 0/16
MongoDBSyracuse 4 5682 0 5682 0/16
Search on 1.4,42.7,8.4,47.5 from 2012-01-01T00:00:00.000Z to 2012-12-31T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 5272 1275 6547 100/324
Syracuse 2 5286 0 5286 100/324
Syracuse 3 5330 0 5330 100/324
Syracuse 4 5348 0 5348 24/324
MongoDBSyracuse 1 10412 8480 18892 100/324
MongoDBSyracuse 2 10514 0 10514 100/324
MongoDBSyracuse 3 10449 0 10449 100/324
MongoDBSyracuse 4 10412 0 10412 24/324
Search on 1.4,42.7,8.4,47.5 from 1995-05-01T00:00:00.000Z to 1995-08-01T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 36 17 53 100/128
Syracuse 2 32 0 32 28/128
Syracuse 3 31 0 31 0/128
Syracuse 4 32 0 32 0/128
MongoDBSyracuse 1 5612 5491 11103 100/128
MongoDBSyracuse 2 5602 0 5602 28/128
MongoDBSyracuse 3 5591 0 5591 0/128
MongoDBSyracuse 4 5599 0 5599 0/128
Search on 1.4,42.7,8.4,47.5 from 2000-08-01T00:00:00.000Z to 2001-02-01T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 108 58 166 100/381
Syracuse 2 126 0 126 100/381
Syracuse 3 146 0 146 100/381
Syracuse 4 168 0 168 81/381
MongoDBSyracuse 1 5632 5510 11142 100/381
MongoDBSyracuse 2 5805 0 5805 100/381
MongoDBSyracuse 3 5656 0 5656 100/381
MongoDBSyracuse 4 5669 0 5669 81/381
Search on 1.4,42.7,8.4,47.5 from 1980-09-01T00:00:00.000Z to 1980-09-08T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 4 1 5 11/11
Syracuse 2 3 0 3 0/11
Syracuse 3 2 0 2 0/11
Syracuse 4 2 0 2 0/11
MongoDBSyracuse 1 5734 5598 11332 11/11
MongoDBSyracuse 2 5710 0 5710 0/11
MongoDBSyracuse 3 5716 0 5716 0/11
MongoDBSyracuse 4 5698 0 5698 0/11
Search on -1,44,6.5,49 from 2012-01-01T00:00:00.000Z to 2012-12-31T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 8730 1616 10346 100/509
Syracuse 2 8678 0 8678 100/509
Syracuse 3 9024 0 9024 100/509
Syracuse 4 8724 0 8724 100/509
MongoDBSyracuse 1 11994 8910 20904 100/509
MongoDBSyracuse 2 12163 0 12163 100/509
MongoDBSyracuse 3 11872 0 11872 100/509
MongoDBSyracuse 4 12125 0 12125 100/509
Search on -1,44,6.5,49 from 1995-05-01T00:00:00.000Z to 1995-08-01T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 36 19 55 100/184
Syracuse 2 42 0 42 84/184
Syracuse 3 42 0 42 0/184
Syracuse 4 42 0 42 0/184
MongoDBSyracuse 1 5621 5492 11113 100/184
MongoDBSyracuse 2 5612 0 5612 84/184
MongoDBSyracuse 3 5621 0 5621 0/184
MongoDBSyracuse 4 5619 0 5619 0/184
Search on -1,44,6.5,49 from 2000-08-01T00:00:00.000Z to 2001-02-01T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 99 62 161 100/665
Syracuse 2 119 0 119 100/665
Syracuse 3 148 0 148 100/665
Syracuse 4 169 0 169 100/665
MongoDBSyracuse 1 5666 5540 11206 100/665
MongoDBSyracuse 2 5716 0 5716 100/665
MongoDBSyracuse 3 5688 0 5688 100/665
MongoDBSyracuse 4 5699 0 5699 100/665
Search on -1,44,6.5,49 from 1980-09-01T00:00:00.000Z to 1980-09-08T23:59:59.999Z
Dataset Page searchTime countTime totalTime Nb Results
Syracuse 1 5 2 7 25/25
Syracuse 2 4 0 4 0/25
Syracuse 3 3 0 3 0/25
Syracuse 4 3 0 3 0/25
MongoDBSyracuse 1 5805 5832 11637 25/25
MongoDBSyracuse 2 5856 0 5856 0/25
MongoDBSyracuse 3 5712 0 5712 0/25
MongoDBSyracuse 4 5702 0 5702 0/25
Done in 17.477333333333334min
AVG Dataset searchTime countTime
Syracuse 1993.52 418.54
MongoDBSyracuse 7191.17 6351.75
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment