Can you run run ADS with the bundled JRE and then provide the following :

1. Can you tell me what Desktop environment you are using? KDE, Gnome, ...
2. Can you provide your application logs from USER_HOME\.datastudio\logs\*
3. Can you proivde the ADS Help->[Support Information] (minus license key).

I think the performance problem you are having is probably a JRE, Desktop or video driver issue.

Answers below; I'd like to point out again that the query result issue does not occur unless the application has been running for 20-30 minutes.  With a fresh start, I can execute anything and it appears almost instantly.  The File->Options problem is there regardless of a clean start.  The below information is with me executing datastudio-bundled.sh

Note that I cleared the logs and did a fresh run with editor Anti Alias and Charts disabled.  Then I went back and reenabled those options and ran again.  I have disabled offscreen capabilities though.  Note that I rarely use the chart functionality.

1. I've experienced the problem in Openbox and KDE.
2. Logs attached
3. See below

Product: Aqua Data Studio
Version: 11.0.11
Build #: 28777
Build Date: 2012-Aug-16 02:57:34 PM

Operating Environment: Linux (3.5-pf, amd64) / UTF-8 / en / US / Sun Microsystems Inc. 1.6.0_27-b07
Memory: Max=954,466,304;  Total=448,724,992;  Free=186,781,480;  CPUs=4

In-Window Graphics Capabilities
Graphics Vendor: Tungsten Graphics, Inc
OpenGL Renderer: Mesa DRI Intel(R) Sandybridge Mobile
OpenGL Version: 3.0 Mesa 8.0.4
Double-Buffering: Enabled
Anti-Aliasing: Disabled
Anti-Aliasing Sample Count: 0
Hardware Acceleration: Enabled
Color Bits: Red: 8  Green: 8  Blue: 8  Alpha: 0
Depth Bits: 24
Accumulation Buffer Bits: Red: 0  Green: 0  Blue: 0
Initialization Time: 652 ms


Offscreen Graphics Capabilities
Graphics Vendor: N/A
OpenGL Renderer: N/A
OpenGL Version: N/A
Double-Buffering: N/A
Anti-Aliasing: N/A
Anti-Aliasing Sample Count: N/A
Hardware Acceleration: N/A
Color Bits: N/A
Depth Bits: N/A
Accumulation Buffer Bits: N/A
Initialization Time: N/A
Hardware PBuffer Available: N/A
Using PBuffer: N/A
Using Ram Buffer: N/A
Offscreen Rendering: N/A
Offscreen Buffer Size: N/A

 

If everything works well for 20 minutes and then it starts to have problems, then my thoughts is that you are running out of memory.  Looks like you have 1Gig allocated.  When you have this problem again, can you see the memory indicator at the bottom right of the application frame to see how much you have left.  Then send me that application log.  The application log you sent doesn't have any problems, but that might just be because you cleared it.  I need the log after the problem occurs.  If you run out of memory then this will be logged.

Ok, I have managed to reproduce the problem, but it does not appear memory related.

According to the memory indicator: 190 / 370 / 910... So ~500mb free.

There is really nothing in the log.  I also ran the garbage collector with no benefit.  Application just hangs anytime I execute a query.  If it's a long running query, the application does not hang until it begins to draw the result grid.

I've also tried disabling every result view except for text.  It does not make a difference.  CPU used by the application is also flat...

Is there any type of debug / trace I could turn on?

The application logs should contain everything you need for debugging.  You could also use the Help->[SQL Log] to see the state of the last query you executed.

Could you also try ADS 12.0 RC?  It is bundled with Java 1.6.0_35 which is the latest.

What might help me diagnose is a screenshot of the application when it is in this state.  Visually I can probably tell what state it is in.

I've added a screenshot - uihangs.png

It will sit in the state for 10-20s with this query.  If I closed ADS and reopen, the query is instant.

While its hanging, the spinner stops and if I resize the window, the window does not repaint until the results are displayed.

Thanks again!

The status bar in the query window indicates "Executing ...", this means that ADS sent the query to the JDBC driver to be executed and is waiting for the driver to repond.  You indicated this was a light query which should be fast, but it is waiting and there is little CPU usage.  This leads me to believe that you probably have a firewall between your client and server which has timeout your connection.  This would go in hand with the fact that it only happens after 20 minutes of usage.  You can do a few things to test this out ...

1. Does this problem occur on all your servers or just some of them?  What are the differences?
2. When this happens, can you open a new query window and execute the query without problems?
3. When this happens, can you cancel and click the reconnect button, then execute without problems?

Actually, if your UI hangs then you can't try that.  It is odd that the UI would hang at that point since ADS isn't trying to do anything to the UI and the only thing working is a separate thread for execution.  Even if the thread had to wait, the UI would still be free to do what it needed.

Did you try ADS 12.0 to see if you experienced this same behavior?

I will upgrade this tomorrow and report back

Same result with ADS 12...

The challenge is that we can't reproduce that here on any of our machines.  We don't run Arch Linux, but Ubuntu. 

Are you experiencing this problem on both your Linux and Windows machines?  Or is the problem isolated to Linux?

Are you running ADS in a VMWare instance or some form of virtualization?

I understand the challenge and I appreciate any help.  It is definitely isolated ot Linux, but I do not run it in a virtualized environment.

I decided to stop focusing on the query results and focus on the other problem - File -> Options.  The application hangs  in the same way the query results do, but it is an easily reproducable problem.

I started with an empty ~/.datastudio directory and registered one server.  I went to File -> Options and the application hung for about 60 seconds.  Finally, the options window popped up.  I closed the application and retried this again - the same results.

Next, I change the look and feel to "Metal" instead of the default "Aqua Data Studio."  I don't particulary like the Metal look, but it does not hang with the File -> Options at all!   Everything is instant.  It will take me a few days before I know if the query analyzer problem is fixed, but there is definitely something with the Aqua Data Studio Look & Feel that is causing it to hang. 

I then went and tested the same scenario on version 12.  It has the same exact behavior, but the second time I go to File -> Options, it's instant.  When I kill the program and start over, the same dleay occurs on the first call to File -> Options.  Again, the Metal look and feel is much quicker.

With the Aqua Data Studio look at feel, File -> Options takes around 55 seconds to appear.  During this period, the application does not repaint itself.  The second call is instant. 

I will keep monitoring the query result performance with the metal look and feel.

Again, I'd like to point out that it is only the option screen that hangs.  ER Modeler, server registration, new query windows, are all snappy.

Thanks again!

The File->Options dialog opens in less then 4 seconds on our Ubuntu 12.04/11.04 machines using the default Aqua Data Studio Look and Feel.  On Windows and OSX they seem to be a little faster.  The 2nd time you open the File->Options dialog it is already created so all it does it show it, and that is why it is always fast.  That means that the construction of the UI components is slow on your machine.

It seems that your issue is a very isolated case, in that it only happens with the Aqua Data Studio LF on the Arch Linux distribution.  The default Aqua Data Studio LF is a JGoodies LF (http://www.jgoodies.com/).  Debugging this could be very expensive and time consuming, and I am sure the problem is in some Arch Linux software distribution package.  By the look of your video card capabilities I would assume the problem is there.  If you really want to get to the bottom of this issue I would recommend creating a VMWare instance running Arch Linux and see if you get the same problem.  The difference between the VMWare instance and your machine will be the video driver.  If it is fast in the VMWare instance then it is probably a hardware video driver issue, while if it is still slow then it is probably a problem with one of the XWindows libraries distributed in Arch Linux.

Luckily I have a stock Ubuntu 12.04 install and Windows 7 installed on this laptop as well.

Windows 7 is almost instant with the ADS look and feel.  Ubuntu 12 is just like Arch - takes 45-60 seconds with the ADS look a feel.  I know I don't have the most capable graphics card, but it is obviously capable given the Windows benchmark.  I'm guessing this is an issue with Linux intel graphics and the JGoodies toolkit.

Also, so far, no more freezes on query executions with the metal look and feel.

This helps.  Can you tell me what you Help->[Support Information] video caps are when running on Ubuntu 12.04?  Mine are :

In-Window Graphics Capabilities
Graphics Vendor: NVIDIA Corporation
OpenGL Renderer: Quadro FX 580/PCIe/SSE2
OpenGL Version: 3.3.0 NVIDIA 295.40
Double-Buffering: Enabled
Anti-Aliasing: Enabled
Anti-Aliasing Sample Count: 16
Hardware Acceleration: Enabled
Color Bits: Red: 8  Green: 8  Blue: 8  Alpha: 0
Depth Bits: 24
Accumulation Buffer Bits: Red: 16  Green: 16  Blue: 16
Initialization Time: 1172 ms

In your Windows run can you run "dxdiag" and provide the video card, manufacter and model?

At this point I am assuming you just have a bad video driver.  In your previous info below you can see that your driver doesn't even have anti-aliasing support.  We use Nvidia proprietary drivers.

I've switched laptops to a Thinkpad W530 with an nVidia K1000m graphics card ( I was due).

Unfortunately, File-> Options with the ADS L&F takes 55+ seconds... even with this powerhouse.

So I started with a clean configuration and tried each option one by one...  I didn't register any servers or open any query windows.  I did start an evaluation period. Still have the delay... This is all with the bundled jre.

In window capabilities:

Vendor    NVIDIA Corporation
Renderer    Quadro K1000M/PCIe/SSE2
OpenGL Version    4.2.0 NVIDIA 304.51
Double-Buffering    Enabled
Anti-Aliasing    Enabled
Anti-Aliasing Sample Count    16
Hardware Acceleration    Enabled
Color Bits    Red: 8  Green: 8  Blue: 8  Alpha: 0
Depth Bits    24
Accumulation Buffer Bits    Red: 16  Green: 16  Blue: 16
Initialization Time    357 ms

Off screen:

Vendor    NVIDIA Corporation
Renderer    Quadro K1000M/PCIe/SSE2
OpenGL Version    4.2.0 NVIDIA 304.51
Double-Buffering    Disabled
Anti-Aliasing    Enabled
Anti-Aliasing Sample Count    16
Hardware Acceleration    Enabled
Color Bits    Red: 8  Green: 8  Blue: 8  Alpha: 8
Depth Bits    24
Accumulation Buffer Bits    Red: 16  Green: 16  Blue: 16
Initialization Time    568 ms
Hardware PBuffer Available    Yes
Using PBuffer    Yes
Using Ram Buffer    No
Offscreen Rendering    Enabled
Offscreen Buffer Size    800x600

I tried it on 3 of our machines and they all take less then 3 seconds.  One of them is a Dell-Vostro laptop which is old and very low end, and it takes 3 seconds.  The machines are running Ubuntu 12.04.  These are the specs for the Dell-Vostro ...

Product: Aqua Data Studio
Version: 12.0.0-rc-23
Build #: 29719
Build Date: 2012-Oct-12 01:27:27 PM

Operating Environment: Linux (3.2.0-23-generic, amd64) / UTF-8 / en / US / Sun Microsystems Inc. 1.6.0_35-b10
Memory: Max=704,643,072;  Total=185,729,024;  Free=86,790,192;  CPUs=4

In-Window Graphics Capabilities
Graphics Vendor: Tungsten Graphics, Inc
OpenGL Renderer: Mesa DRI Intel(R) Ironlake Mobile
OpenGL Version: 2.1 Mesa 8.0.2
Double-Buffering: Enabled
Anti-Aliasing: Disabled
Anti-Aliasing Sample Count: 0
Hardware Acceleration: Enabled
Color Bits: Red: 8  Green: 8  Blue: 8  Alpha: 0
Depth Bits: 24
Accumulation Buffer Bits: Red: 0  Green: 0  Blue: 0
Initialization Time: 1027 ms

Sorry it's been a while; things have gotten busy!

I did make progress on finding the issue... To my surprise, my clipboard manager is the problem.

Specifically, ADS triggers the XOrg selection clipboard event many times when you open the options dialog.  The selected text is "Tab"  Interestingly, every clipboard manager except for KDE's clipboard tool triggers the delay in ADS.  It is also only the ADS look and feel that triggers this event; using the Metal L&F does not trigger it.

Clipboard managers that fail:

glipper
parcellite
clipit
xclip
glippy
loliclip

I've used parcellite for 2+ years and never had this type of issue, so I'm guessing it's directly related to the jGoodies toolkit.

How do you know it is triggering the selection clipboard event?  Is there a way to monitor this?  I'd like to be able to monitor this so that I can reproduce and debug.

Having trouble finding many tools, but I did find this:

http://api.metacpan.org/source/KRYDE/X11-Protocol-Other-20/examples/xfixes-selection.pl

It seems to both trigger the problem and report the each event.

I've attached files with the detailed logs and a simple timestamp.

Summary:

Creating a new tab with the ADS LF: 17 events
Creating a new tab with the Metal LF: 0 events
File->Options Metal LF: 109 events
File->Options ADS LF: 195 events

Seems like none of these events should be trigger while the window is being drawn.  I tested a few other applications out and could not replicate this behavior.  I also tested a few other java programs with option UIs and could not replicate the event being fired.

Not sure if this helps, but I downladed the only other java SQL client I know of - sQuirrel SQL Client 3.4.0.  To my surprise, they offer three jGoodies L&F options.  I could not get their implementation of the L&F to trigger the clipboard event.

ADS v10/v11/v12 use jgoodies looks 2.1.4.  The latest is 2.5.2.  I tried updating the jar but looks like enough has changed which prevents ADS from running. 

We installed Arch Linux and run Aqua Data Studio on it.  File->Options opened in 2-3 seconds.  See attached screenshot.  I don't think this is a bug in Aqua Data Studio as we can't reproduce this on any platform.  It is possible you are installing a specific piece of software that is causing this behavior, but I am not sure what it is.

From Emilian : >> Actually this duplicates on Ubuntu 12.04 if you install parcellite

Latest version of parcellite is 1.0.2-rc5

https://launchpad.net/ubuntu/precise/+package/parcellite
http://parcellite.sourceforge.net/

I just installed parcellite from the official Ubuntu repository using aptitude.

When I stared parcellite manually in a terminal, Options was displaying much slower.

The LnF was *not* a factor and seemed to run slow with Metal too. Just make sure to restart ADS as only the first display takes longer with parcellite. After the 1st display, I think the dialog is cached and shows up much faster.