SQLQueryPlugin very slow

I use SQLQueryPlugin to connect to hsqldb 1.7.1. When I issue a request, the result takes several seconds to appear. This is strange because in status bar of the plugin, the display shows "Execution time:15ms" which means that the result should be instantly available. The result set of the request is just a few db lines. Any Ideas on what's going on ?

Thanks,

Richard

4 comments

The time 15ms are the time used for getting the data from the resultset and creating the table model. The only time not in execution time
is the time used for closing the statement.

Bye, Stefan

Richard De Falco wrote:

I use SQLQueryPlugin to connect to hsqldb 1.7.1. When I issue a request, the result takes several seconds to appear. This is strange because in status bar of the plugin, the display shows "Execution time:15ms" which means that the result should be instantly available. The result set of the request is just a few db lines. Any Ideas on what's going on ?

Thanks,

Richard

0

It seems, that there is something happening before the execution of the statement. As soon as the slider bar to the right is moving the results are shown almost immediately. In the meantime the "execute query button" stay selected for several seconds, and idea freeze completely (sql plugin and all the editors panes). I think it is a problem that has something to do with idea integration, not with jdbc.

Richard

0

I see the same behaviour. I'm connecting to a DB2 database on a remote machine.
This used to work OK, I'm not sure what changed that introduced the problem (apart from regular upgrades of IDEA, I'm on 1172 now).

Andrei

R> It seems, that there is something happening before the execution of
R> the statement. As soon as the slider bar to the right is moving the
R> results are shown almost immediately. In the meantime the "execute
R> query button" stay selected for several seconds, and idea freeze
R> completely (sql plugin and all the editors panes). I think it is a
R> problem that has something to do with idea integration, not with
R> jdbc.
R>
R> Richard
R>

0

I use the plugin for a MySQL and an Oracle database (the Oracle database is on a remote machine) and have no problems of this kind. Looking at the source code the only reason for this behaviour I see is the creation of the classloader that include the project classpath. You could try to connect from an empty project. If this solves the problem I could make the use of the project classpath optional.

0

Please sign in to leave a comment.