Skip to content

Instantly share code, notes, and snippets.

@zzzeek
Last active December 20, 2015 14:08
Show Gist options
  • Save zzzeek/6143700 to your computer and use it in GitHub Desktop.
Save zzzeek/6143700 to your computer and use it in GitHub Desktop.
# script: https://github.com/zzzeek/sqlalchemy/blob/master/test/perf/orm2010.py
# cpython 2.7 with no C extensions
classics-MacBook-Pro:sqlalchemy classic$ export PYTHONPATH=lib/
classics-MacBook-Pro:sqlalchemy classic$ python test/perf/orm2010.py
0 - Added 1000 boss objects
3 - Added 100000 grunt objects
29 - Associated grunts w/ bosses and committed
29 - Heavy query run #1
37 - Heavy query run #2
45 - Heavy query run #3
53 - Heavy query run #4
61 - Heavy query run #5
Total time: 69
# cpython 2.7 with C extensions
classics-MacBook-Pro:sqlalchemy classic$ export PYTHONPATH=build/lib.macosx-10.4-x86_64-2.7/
classics-MacBook-Pro:sqlalchemy classic$ python test/perf/orm2010.py
0 - Added 1000 boss objects
3 - Added 100000 grunt objects
28 - Associated grunts w/ bosses and committed
28 - Heavy query run #1
36 - Heavy query run #2
43 - Heavy query run #3
50 - Heavy query run #4
58 - Heavy query run #5
Total time: 65
# cpython 3.3 with C extensions
classics-MacBook-Pro:sqlalchemy classic$ export PYTHONPATH=build/lib.macosx-10.8-x86_64-3.3/
classics-MacBook-Pro:sqlalchemy classic$ python3.3 test/perf/orm2010.py
0 - Added 1000 boss objects
3 - Added 100000 grunt objects
28 - Associated grunts w/ bosses and committed
28 - Heavy query run #1
35 - Heavy query run #2
41 - Heavy query run #3
48 - Heavy query run #4
54 - Heavy query run #5
Total time: 61
# pypy 1.9
classics-MacBook-Pro:sqlalchemy classic$ /usr/local/src/pypy-1.9/bin/pypy test/perf/orm2010.py
0 - Added 1000 boss objects
0 - Added 100000 grunt objects
19 - Associated grunts w/ bosses and committed
19 - Heavy query run #1
25 - Heavy query run #2
30 - Heavy query run #3
33 - Heavy query run #4
37 - Heavy query run #5
Total time: 41
# pyyp 2.1beta2
classics-MacBook-Pro:sqlalchemy classic$ /usr/local/src/pypy-2.1-beta2-osx64/bin/pypy test/perf/orm2010.py
0 - Added 1000 boss objects
0 - Added 100000 grunt objects
17 - Associated grunts w/ bosses and committed
17 - Heavy query run #1
22 - Heavy query run #2
26 - Heavy query run #3
29 - Heavy query run #4
32 - Heavy query run #5
Total time: 35
@sakjur
Copy link

sakjur commented Aug 3, 2013

On line #54, s/pyyp/pypy/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment