Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#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 1 of 3)
  • Bron Eubanks
    Bron Eubanks
    2007-07-20

    • priority: 5 --> 7
     
  • Rob Manning
    Rob Manning
    2007-07-20

    • labels: --> Core
    • assigned_to: nobody --> manningr
     
  • Rob Manning
    Rob Manning
    2007-07-20

    Logged In: YES
    user_id=1287991
    Originator: NO

    I have used it everyday in every version since 1.2 on a variety of hardware and operating systems and I've never seen this kind of poor performance. There has been much work to allow the UI to continue to be responsive during long running tasks. Although, it sounds like the tasks you are describing should be relatively quick. It might help us if you could post your log (<user.home>/.squirrel-sql/logs/squirrel-sql.log) since it will contain timing statements in it and we could further characterize this behavior. When you say minutes for a single query, does the result set contain a large number of records / data. What are you pasting, plain text? Do you use LOB (CLOB/BLOB) fields? For the restoring from the taskbar to a grey window, I can recall seeing that before, although I typically use virtual desktops in windows (VirtuaWin) so I never minimize most applications (just place them on different desktops and use the desktop switcher hot-key - it's faster).

    Rob

     
  • Bron Eubanks
    Bron Eubanks
    2007-07-20

    Logged In: YES
    user_id=1842742
    Originator: YES

    Thanks for the reply. I'll work on getting a log with debug mode enabled.

    Performance is bad for a variety of result set sizes (even one record). Never used it with BLOBS/CLOBS yet.

    Pasting plain text. Even a single, short line can be slow.

    I've used VirtuaWin before, but it got too inconvenient for me. I do use two monitors, though.

     
  • Gerd Wagner
    Gerd Wagner
    2007-07-23

    Logged In: YES
    user_id=776065
    Originator: NO

    I use SQuirreL on XP every day without any of those performance problems. Sometimes the Look and Feel can reduce performance (though I never saw anything like described here). Try to use the Metal Look and Feel with Ocean theme (Sun's default). Also make sure you unchecked New Session Properties --> Object tree --> Show Row count for tables.

     
  • Bron Eubanks
    Bron Eubanks
    2007-07-23

    Logged In: YES
    user_id=1842742
    Originator: YES

    Attached is a log. There are a lot of exceptions being thrown. I had to delete the startup info from the log to make the file small enough to submit.

    I've tried both the default L&f and the Windows L&F. (I figured since I'm running it on Windows, maybe the Windows one would allow some hardware acceleration.)
    File Added: squirrel-sql.log.2007-29

     
  • Bron Eubanks
    Bron Eubanks
    2007-07-23

    Logged In: YES
    user_id=1842742
    Originator: YES

    By the way, I just tried upgrading my DB2 driver to no avail. Also, if you need the beginning part of the log file, just let me know, because I still have it.

     
  • Rob Manning
    Rob Manning
    2007-07-23

    Logged In: YES
    user_id=1287991
    Originator: NO

    What version is the log file from? (I can't tell with the log beginning cut out)

    Rob

     
  • Bron Eubanks
    Bron Eubanks
    2007-07-23

     
    Attachments
1 2 3 > >> (Page 1 of 3)