id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 24224 sqlmigrate is slow TorstenRottmann nobody "When requesting an '''sqlmigrate''' (or when doing a '''test''' or '''migrate''' also), it takes a very long time to compute the sql for a particular app migration. This app has some 78 models and is highly interconnected with ForeignKeys (100+).[[BR]] I ran the '''sqlmigrate''' through the profiler an got these results:[[BR]] {{{ 74628367 function calls (74229507 primitive calls) in 132.448 seconds Ordered by: internal time ncalls tottime percall cumtime percall filename:lineno(function) 552977 18.515 0.000 29.690 0.000 __init__.py:292(deconstruct) 40096 14.144 0.000 19.827 0.000 related.py:276(swappable_setting) 318698 11.825 0.000 20.907 0.000 __init__.py:1011(__init__) 575182 9.425 0.000 12.465 0.000 __init__.py:123(__init__) 571729 7.252 0.000 96.117 0.000 state.py:277(construct_fields) 16773892/16722006 6.668 0.000 6.707 0.000 {getattr} 85138 2.822 0.000 4.825 0.000 __init__.py:1092(__init__) 553122/553106 2.799 0.000 6.470 0.000 {__import__} 637429/318719 1.908 0.000 2.137 0.000 deconstruct.py:15(__new__) 3236790 1.900 0.000 1.900 0.000 {method 'startswith' of 'unicode' objects} 3881364/3881362 1.884 0.000 4.418 0.000 {isinstance} 5915601 1.548 0.000 1.812 0.000 options.py:283(_swapped) 43868 1.507 0.000 1.507 0.000 base.py:33(subclass_exception) 901714 1.491 0.000 2.534 0.000 abc.py:128(__instancecheck__) 21946/19820 1.472 0.000 24.363 0.001 base.py:61(__new__) 2395625 1.467 0.000 1.467 0.000 {hasattr} 11291797 1.448 0.000 1.460 0.000 {method 'get' of 'dict' objects} 298364 1.394 0.000 6.343 0.000 __init__.py:572(contribute_to_class) 553078/553076 1.375 0.000 8.543 0.000 __init__.py:20(import_module) ... }}} Waiting more than a minute for a test to start is very annoying ... My first question, when looking at the profile is: What is imported there over half a million times? " Cleanup/optimization closed Migrations 1.7 Normal duplicate migration slow Unreviewed 0 0 0 0 0 0