SQL support and high cpu usage

Just a heads up.

Our project contains several .sql files. While we understand there is no support for Oracle/MS SQL or DB2, we have noticed the editor shows errors in them and when this files are quite large (i.e over 2k lines), just inserting a line or pasting new lines, make Idea cpu usage goes hot (100%) for minutes in a MBP with 3 GB ram.
jvm options: -Xms16m -Xmx512m -XX:MaxPermSize=196m

We have to disable sql support plugin and we can edit this .sql files now.
Also I was wondering if we can disable sql support just for some files (we do have some MySQL files and we did not see any problems with those).

Thanks,
Gustavo.

2 comments
Comment actions Permalink

Hello Gustavo,

Just a heads up.

Our project contains several .sql files. While we understand there is
no support for Oracle/MS SQL or DB2, we have noticed the editor shows
errors in them and when this files are quite large (i.e over 2k
lines), just inserting a line or pasting new lines, make Idea cpu
usage goes hot (100%) for minutes in a MBP with 3 GB ram.

Idea settings are 768 mb.

We have to disable sql support plugin and we can edit this .sql files
now. Also I was wondering if we can disable sql support just for some
files (we do have some MySQL files and we did not see any problems
with those).


Please file a JIRA issue with a CPU snapshot attached, so that we can see
what exactly causes the problem and fix it.

--
Dmitry Jemerov
Development Lead
JetBrains, Inc.
http://www.jetbrains.com/
"Develop with Pleasure!"


0

Please sign in to leave a comment.