Encountering slowness in datasources with large # of tables
I am working with a database with over 3000 tables in it and it seems to encounter a significant slowdown when I do the following.
Go into data sources
Click the minus sign on my specific datasource and then click the minus next to my database to list all the tables.
The list will popdown but then pycharm will become unresponsive and the loading icon shows up to the right of my database name under datasources. It will take anywhere between 5 to 10 minutes for Pycharm to start responding again.
I am connecting to an SQL Server 2005 DB running on windows 2008 using the jtds driver that is downloadable through pycharm when adding my datasource. Is this to be expected since there are so many tables? Other smaller databases seem to run much faster so I am going to experiment with the table filtering but was curious if others observed this issue.
Please sign in to leave a comment.
Could you please submit a CPU snapshot? You can find instructions for this at: http://devnet.jetbrains.net/docs/DOC-1212
This is the cpu snapshot requested.
The actions taken during the snapshot where the following.
opened my datasource window
clicked the plus next to my database to show all the tables
tried to click on one of the tables
When it finally highlighted the table and pycharm became responsive again I ended the snapshot. Sorry for the delay in providing this information. Please let me know if there is anything else you need.
Thanks!
-Josh
Attachment(s):
PY-111.107_sarvej_06.01.2012_15.53.22.zip
http://youtrack.jetbrains.com/issue/IDEA-94535
Hopefully we'll be able to address the problem in the forthcoming PyCharm 2.7 release.