Sorted Textual SQL profile
ncalls tottime percall cumtime percall filename:lineno(function)
16 1.840 0.115 1.840 0.115 {method 'execute' of
'pyodbc.Cursor' objects}
9572 0.196 0.000 0.788 0.000 elements.py:1860(_construct)
57700 0.189 0.000 0.189 0.000 {method 'sub' of
'_sre.SRE_Pattern' objects}
9567 0.185 0.000 0.185 0.000 {method 'fetchone' of
'pyodbc.Cursor' objects}
100329/99724 0.125 0.000 0.142 0.000 {built-in method
isinstance}
19123 0.120 0.000 0.200 0.000 elements.py:1225(__init__)
1 0.117 0.117 5.042 5.042 del_test.py:1(<module>)
19123 0.100 0.000 0.222 0.000
compiler.py:737(visit_textclause)
38254/9571 0.099 0.000 0.566 0.000 compiler.py:806(<genexpr>)
28738/14 0.096 0.000 0.598 0.043
visitors.py:75(_compiler_dispatch)
19123 0.086 0.000 0.286 0.000 elements.py:1240(_create_text)
38254/9571 0.079 0.000 0.585 0.000 compiler.py:804(<genexpr>)
12693/3132 0.068 0.000 0.603 0.000 {method 'join' of 'str'
objects}
1 0.065 0.065 3.811 3.811 db_base.py:138(dict_delete)
9561 0.062 0.000 0.398 0.000 db_base.py:178(<listcomp>)
9571 0.060 0.000 0.240 0.000 elements.py:1883(<listcomp>)
28695 0.060 0.000 0.156 0.000
elements.py:4216(_expression_literal_as_text)
28716 0.058 0.000 0.096 0.000
elements.py:4220(_literal_as_text)
9562 0.052 0.000 0.317 0.000 result.py:1156(fetchone)
9562 0.051 0.000 0.105 0.000
operators.py:1007(is_precedent)
50154 0.050 0.000 0.050 0.000 {method 'append' of 'list'
objects}
19123 0.050 0.000 0.336 0.000 <string>:1(text)
9572 0.048 0.000 0.203 0.000 elements.py:1865(<listcomp>)
27063/27061 0.047 0.000 0.048 0.000 {built-in method getattr}
2 0.044 0.022 0.045 0.022 {built-in method connect}
9571/10 0.037 0.000 0.595 0.059
compiler.py:797(visit_clauselist)
9562 0.037 0.000 0.534 0.000 elements.py:1894(and_)
28683 0.036 0.000 0.036 0.000 del_test.py:14(<genexpr>)
9562 0.036 0.000 0.057 0.000 result.py:1085(process_rows)
9561 0.029 0.000 0.159 0.000 elements.py:1971(self_group)
28504/28389 0.028 0.000 0.028 0.000 {built-in method len}
125 0.026 0.000 0.026 0.000 {built-in method loads}
750/724 0.026 0.000 0.340 0.000 {built-in method
__build_class__}
9561 0.025 0.000 0.560 0.000 <string>:1(and_)
9561 0.024 0.000 0.130 0.000 elements.py:1818(self_group)
9562 0.024 0.000 0.341 0.000 result.py:868(__iter__)
9564 0.022 0.000 0.207 0.000 result.py:1053(_fetchone_impl)
9572 0.022 0.000 0.032 0.000
_collections.py:788(coerce_generator_arg)
9562 0.021 0.000 0.021 0.000 result.py:1098(<listcomp>)
19122 0.021 0.000 0.021 0.000 elements.py:1601(self_group)
21232 0.021 0.000 0.021 0.000 {method 'get' of 'dict'
objects}
10 0.019 0.002 0.019 0.002 {method 'commit' of
'pyodbc.Connection' objects}
19123 0.019 0.000 0.019 0.000
compiler.py:734(post_process_text)
290/1 0.016 0.000 5.044 5.044 {built-in method exec}
68 0.015 0.000 0.042 0.001 inspect.py:264(getmembers)
361 0.014 0.000 0.103 0.000 inspect.py:943(getfullargspec)
2884 0.014 0.000 0.020 0.000 sre_parse.py:197(__next)
10420 0.013 0.000 0.013 0.000 {built-in method __new__ of
type object at 0x7f9abdca4e40}
9561 0.012 0.000 0.012 0.000 result.py:168(keys)
361 0.012 0.000 0.065 0.000 inspect.py:2383(from_function)
714 0.010 0.000 0.018 0.000 inspect.py:1056(formatargspec)
296 0.010 0.000 0.041 0.000 <frozen
importlib._bootstrap>:2016(find_spec)
4486/4198 0.010 0.000 0.015 0.000 {built-in method hasattr}
130/38 0.010 0.000 0.044 0.001 sre_parse.py:448(_parse)
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
