Re: [Sqlalchemy-tickets] [sqlalchemy] #2720: new C extensions for attribute accessing

[sqlalchemy <mi...@zz...>]

#2720: new C extensions for attribute accessing
-----------------------------------+---------------------------------------
      Reporter:  zzzeek            |      Owner:  zzzeek
          Type:  enhancement       |     Status:  new
      Priority:  medium            |  Milestone:  0.9.0
     Component:  cextensions       |   Severity:  very major - up to 2 days
    Resolution:                    |   Keywords:
Progress State:  not decided upon  |
-----------------------------------+---------------------------------------

Comment (by claudiofreire):

 Alright, virtualenv in place,

 Unpached (no cinstrumented):

 {{{
 (env)claudiofreire@klaumpp:~/src/SQLAlchemy-0.8.1>
 PYTHONPATH=$(pwd)/build/lib.linux-x86_64-2.7/ python
 test/perf/orm2010read.py
 /home/claudiofreire/src/SQLAlchemy-0.8.1/build/lib.linux-
 x86_64-2.7/sqlalchemy/types.py:307: SAWarning: Dialect sqlite+pysqlite
 does *not* support Decimal objects natively, and SQLAlchemy must convert
 from floating point - rounding errors and other issues may occur. Please
 consider storing Decimal numbers as strings or integers on this platform
 for lossless storage.
   d[coltype] = rp = d['impl'].result_processor(dialect, coltype)
 SQLA Version: 0.8.1
 Total calls 706284
 Total cpu seconds: 1.94
 Total execute calls: 101
 Total executemany calls: 0
 sh: runsnake: command not found
 }}}

 Patched (with cinstrumented):
 {{{
 (env)claudiofreire@klaumpp:~/src/SQLAlchemy-0.8.1>
 PYTHONPATH=$(pwd)/build/lib.linux-x86_64-2.7/ python
 test/perf/orm2010read.py
 /home/claudiofreire/src/SQLAlchemy-0.8.1/build/lib.linux-
 x86_64-2.7/sqlalchemy/types.py:307: SAWarning: Dialect sqlite+pysqlite
 does *not* support Decimal objects natively, and SQLAlchemy must convert
 from floating point - rounding errors and other issues may occur. Please
 consider storing Decimal numbers as strings or integers on this platform
 for lossless storage.
   d[coltype] = rp = d['impl'].result_processor(dialect, coltype)
 SQLA Version: 0.8.1
 Total calls 646370
 Total cpu seconds: 1.69
 Total execute calls: 101
 Total executemany calls: 0
 sh: runsnake: command not found
 }}}

 Will attach orm2010read.py, with emphasis on read-only stuff.

-- 
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2720#comment:11>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python