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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.