I stripped everything 'sensitive' from my project to make a clean one ready to share with you. The result is still slow to debug but it is bearable.
The sample project is available for download from
. Just set up a database in settings.py and sqlall to it.
It looks like with the full version of my project, hitting F10 to step through the code takes ~5 seconds (even on no-op lines), and makes the python console pop up back on top of the other windows and then go back to the background before visual studio comes
back to life on the next line.
However after a bit more investigation, it looks like the slowness is directly related to the lag between the machine where I am debugging and the MySQL server. When the MySQL server is on localhost, the debugging experience is much better, even when debugging
code that has nothing to do with the database. How can this be explained?
: I confirm that having the mysql server on localhost is a complete game changer.
[Zooba: This is because the object representing a query is actually running the query when we call
repr on it. The real fix is to fix the object so it doesn't do this, but we should also look into some way to prevent the problem becoming so bad it causes complaints.]