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.

4 comments
Comment actions Permalink

Could you please submit a CPU snapshot? You can find instructions for this at: http://devnet.jetbrains.net/docs/DOC-1212

0
Comment actions Permalink

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
0
Comment actions Permalink
I am still having this issue and was wondering what the status was on this.  Thanks!
0
Comment actions Permalink
I'm sorry that we've missed your snapshot and did not review the problem until now. I've filed a YouTrack issue:
http://youtrack.jetbrains.com/issue/IDEA-94535
Hopefully we'll be able to address the problem in the forthcoming PyCharm 2.7 release.
0

Please sign in to leave a comment.