#532 Major Performance Problems

All
open-postponed
Rob Manning
Core (461)
7
2007-09-18
2007-07-20
Bron Eubanks
No

I've noticed some very poor performance in Squirrel. (In fact, "noticed" is an understatement. I've tried everything I could think of, and I've never seen any other Java application perform this poorly.) I've looked through the forums and FAQ's and even Google'd for this, and I can't find anyone else complaining about it. In almost every scenario I've tested it in, it has performed very slowly. The only times it has been reasonably fast is when using a small hypersonic db (<10 tables) locally on my laptop (which is a decently fast laptop).

Symptoms:
1. A simple paste operation into an editor usually takes 2-3 minutes (sometimes a lot longer).
2. SQL Query Execution usually takes minutes for a single query. Sometimes it could take 10-15 minutes. (And no, I'm not sure why I persist in using Squirrel under those circumstances.)
3. Restoring the window from the Windows taskbar yields a gray window for a minute or two before it gets around to rendering the application.
4. Many other extremely simple operations have unacceptable delays.

In ALL of the above examples, CPU usage is almost unaffected by the long wait. It just sits idle for minutes (literally) before completing simple operations.

Environment Tested In:
* DB Server: DB2 (v.8.2, I think)
* Network Connection: Excellent connection at 100Mbps, same network as the server. I know the communication with the server is fine b/c my web apps perform just fine on JBoss connected to the db.
* 3 Different Computers, all WinXp, all performed slowly with Squirrel.
* Squirrel Versions Tested: 2.2, 2.3, 2.4, 2.5, 2.5.1
* Java Versions Tested: JDK 5.0, JDK 6.0

* It's slow with or without lots of plugins. I typically run with as few as possible.
* I do use the db2 plugin in Squirrel 2.5 ... still slow.

Has anyone else out there experienced this?

Discussion

<< < 1 2 3 (Page 3 of 3)
  • kamgan
    kamgan
    2007-09-17

    Logged In: YES
    user_id=1892472
    Originator: NO

    I experienced the same issue. It wasn't consistent. That is why I upgraded to version 2.5 and it hasn't been happening. Yet, my object tree for tables will not populate

     
  • Rob Manning
    Rob Manning
    2007-09-18

    • status: open --> open-postponed
     
  • Rob Manning
    Rob Manning
    2007-09-18

    Logged In: YES
    user_id=1287991
    Originator: NO

    I looked at replacing the netbeans libraries we currently use with the latest version (5.5). Although the APIs that we use were still available, the behavior was quite different. We've shelved this upgrade for now as it is probably something we want to do as the focus of a release, starting at the beginning of the development cycle - to give enough time for testing.

    Rob

     
  • Logged In: NO

    I had problems the first time I tried the client. It constantly sucked the
    lifeforce out of my system resouces, then hung. I have found the program
    to have many bugs when compiled from source. Tools run on the application
    show hundreds of serious bugs.

     
  • Logged In: NO

    I have these problems too.
    When I try to open a small file (3kb) the application freezes for some minutes.
    If I try to open another file, in same session that I opened the first file, it is loaded very fast.
    While the file is loading slowly, no extra memory is alocated and the processor use is 0%.

    I think that this problem can be caused by the text area creation or management.

    But, despite of this problem happens, squirrel is a fantastic tool.

     
  • Bron Eubanks
    Bron Eubanks
    2009-01-09

    For me the problem seemed mostly resolved in the 2.6.x versions, but copy-paste is sometimes [inconsistently] extremely slow in a 3.0 early build (20090107). Is 3.0 still using the same version of the Netbeans editor? Netbeans seems to be the primary problem.

     
  • Bron Eubanks
    Bron Eubanks
    2009-10-16

    Confirming that problem still occurs in version 3.0.2. I still think Squirrel + DB2 = slow. Even still, since other people with DB2 are not getting this, maybe the DB2 side of the problem is specific to my DB2 configuration.

     
<< < 1 2 3 (Page 3 of 3)