All Forums Teradata Studio
ecorcoran 1 post Joined 07/13
25 Jul 2013
Using SQL History tab slows Studio to a crawl

Whenever I interact with the SQL History tab in any way, it causes both Studio and Studio express to slow to a crawl on my machine. The application will become unusable for minutes at a time. This happens if there is even one entry in the SQL History tab. Since I have to use the SQL History tab to figure out why code didn't run, this is a serious problem for me. 
I'm using a Macbook Pro running Mountain Lion. Teradata Studio version is 14.02.0.201302060329. Java version is 1.6.0_51

Chuckbert 78 posts Joined 07/09
31 Jul 2013

We have seen issues with Studio and Studio Express becoming slow when a query has been run and many more than the default limit of 2000 rows are displayed in the Result Set Viewer. Have you by any chance run a query with a very large result set and had the entire result set displayed?
You've said the problem is when interacting with the SQL History. If the history tab is not displayed, is the rest of the application responsive? The slowing occurs only after the history tab is displayed?

AndrewSchroter 14 posts Joined 11/06
19 May 2014

I found that disconnecting all connections helps speed things up as far as saving SQL editor files.  Terminating Teradata Studio after that and starting back up brings back good performance.  Seems like its doing a lotof housekeeping (memory leaks, paging?)
 

rajgupta914 1 post Joined 01/14
04 Sep 2015

Has there been any update to this?  I am having the same problem and it really slows my development process.

fgrimmer 553 posts Joined 04/09
04 Sep 2015

Rajiv, What version of Studio are you using? The original post was a couple of year ago. Since, we have upgraded to a later version of Eclipse as the base for Studio, as well as, increased the heap space allocation.

jfigge 1 post Joined 03/13
13 Jan 2016

This is still happening today on version 15.10.01.  I have just 36 records in the history and it's slowed to a crawl.  I've already upped the memory to 2048Mb and have turned off all auto-complete aids.  There's also a problem, perhaps it's related, that on some (large?) queries it can take a very long time just to start the submit.  the delay is between pressing F5 and the spinning wait icon in the bottom right corner appearing.
I love the tool as it's very powerful once you start exploring the options, but man is it tought to work through these slow downs.  Running on a TD issued Mac Book pro - 2015

fgrimmer 553 posts Joined 04/09
13 Jan 2016

Jason, What version of Mac OSX and JRE are you running?

superwyb 1 post Joined 11/15
26 Jan 2016

Hi
I have same issue with my TS on Mac.
Here are my env.
------------------
Teradata Studio version: 15.10.10.201511052035
Jre version: 1.8.0_65
MAC OS Version: 10.11.3
------------------
It looks like if there is failed sql in the history, TS tried to refresh something in the backend.
It goes back normal when I clean up the error statement in the SQL History.
Hope those helps.
Bob Wang
 

fgrimmer 553 posts Joined 04/09
27 Jan 2016

Thanks for the input. We will try to recreate the issue and get it resolved.

fgrimmer 553 posts Joined 04/09
27 Jan 2016

@superwyb, How many entries are in your SQL History?

sfought 5 posts Joined 10/14
28 Jan 2016

I have this issue too with 122 entries in the history.  I have to force quit the app to recover control.
 
Teradata Studio version: 15.10.01.01 (I think, see below)
JRE version: 1.8.0_71

MAC OS Version: 10.11.3

 

 
I'll gladly try an alpha to fix this issue.

sfought 5 posts Joined 10/14
28 Jan 2016

See attached image for more version numbers.

fgrimmer 553 posts Joined 04/09
28 Jan 2016

@sfought, OK, I will increase the entries and see if I can his this issue. thanks.

sfought 5 posts Joined 10/14
25 Feb 2016

Any update on this issue?  Thanks.

fgrimmer 553 posts Joined 04/09
26 Feb 2016

@sfought, I upped the number of entries in my SQL History to over 150 and still no slow down in the SQL Editor. My queries are not long (a single select, a few lines long) nor taking a long time to run. Some returning large result sets. Some failing to force failures in SQL History. But still no slow down. 

sfought 5 posts Joined 10/14
01 Mar 2016

Could you please share the version TS you are using, Java VM type and version, any changes you have made to the VM and the type and configuration of the computer you are using?
Thanks,
Scott

ssavoye 15 posts Joined 05/11
16 Mar 2016

Hello,
I've had tremendous slow downs using Teradata Studio on a Macbook Pro (brand new) with 16 GB of memory on OS X Yosemite Version 10.10.5.  Sometimes it is the editor and sometimes the History windows are too slow to use.  I can type a line very quickly and then just sit back and slowly watch the characters appear on the screen for 15-30 seconds.  This is working with very little data, and mostly just coding for a stored procedure.  It is virtually unusable.
Other times, it takes for ever to scroll through the History window or resize a window.
We have way too many people on Macs at this new TD customer to attempt to roll this out as such.  Who can help resolve the issue within Teradata?  I see so many threads on this and have tried most of the suggestions that I have seen.
The only anomoly is that we are pointing this at Teradata on a VM to test and play, but the response back from the DB is reasonable for being a VM.
1) I don't have SQL Code Assist Autoactivation turned on.
2) The activity Monitor shows TD Studio at about 500 MB.  So, I increased the Xmx parameter in the TeradataStudio.ini file as such from 512m (still slow):
--launcher.library
../../../plugins/org.eclipse.equinox.launcher.cocoa.macosx.x86_64_1.1.200.v20150204-1316
-vmargs
-XstartOnFirstThread
-Dorg.eclipse.swt.internal.carbon.smallFonts
-Dosgi.requiredJavaVersion=1.6
-Xms512m
-Xmx2028m
-XX:MaxPermSize=512m
-Djava.util.Arrays.useLegacyMergeSort=true
 
TD Studio version info: 15:10:11.201601.....
java -version
java version "1.8.0_73"
Java(TM) SE Runtime Environment (build 1.8.0_73-b02)
Java HotSpot(TM) 64-Bit Server VM (build 25.73-b02, mixed mode)
 
Thank you for any help,
Steve
 

fgrimmer 553 posts Joined 04/09
17 Mar 2016

Steve,  We have not been able to recreate the slow down issue but here is a posting from a user that found a solution. Please let me know if this works for you as well.
"I'm on OSX El Capitan 10.11.3. My Java Control Panel showed I had the recommended version installed. I discovered that my Temporary Internet Files settings for Java were set to allow 32GB of temp files. I reduced the limit to about 5GB and used "Delete files..." for Trace and Log Files and Cached Applications and Applets. 
Now for me the application is running faster than it ever has before."
 

ssavoye 15 posts Joined 05/11
17 Mar 2016

No effect.  I now have admin rights to my Mac and made the changes suggested in this exchange with regard to Java temp files as shown above.  Traversing the SQL History is still painfully slow.  I have restarted the machine several times, killed and closed other applications and it is still painfully slow.
Did I miss anything in my changes?  What else can I try? We use Chrome here.  Are there any issues there?  Where does the data and the databse reside for the SQL history?  What kind of DB is it?
 

fgrimmer 553 posts Joined 04/09
17 Mar 2016

The SQL History is stored in a Derby database within the Studio workspace. Is your workspace created locally and not on a remote location?

ssavoye 15 posts Joined 05/11
17 Mar 2016

I am working directly on my Macbook and it should all be local.  The only anomoly, as mentioned earlier, is that we are pointing at a VM for the interim.  Is there a setting as to where the history could reside elsewhere?

fgrimmer 553 posts Joined 04/09
17 Mar 2016

There currently is not a setting to store the SQL History elsewhere, but since your SQL History is stored locally not sure that would help. I am guessing you have tried clearing the SQL History? 

fgrimmer 553 posts Joined 04/09
17 Mar 2016

From your earliar post, the workspace location can be changed when you launch with the -data command line option.

ssavoye 15 posts Joined 05/11
17 Mar 2016

I did not clear my SQL History.  Should I?  IT will scroll fast if its is empty.  :-)  I only have 106 rows in it.  I see where the projects are stored in the StudioWorkspace under Documents on my local drive.  However, I was just reading the install guide again, and it says a workspace folder called SQLA should be created.  I don't see that.  I read how you change the location, but it is all local.  I just don't see SQLA in that workspace folder, so where is it residing?  Is there a way to check?

ssavoye 15 posts Joined 05/11
17 Mar 2016

So you know what I tried.  I first exported the old SQL History.  I created a SQLA directory in my StudioWorkspace directory and then ran the TeradataStudio command to change the workspace as such
 

  1. /Applications/TeradataStudio/Teradata/Studio.app/Contents/MacOS/ TeradataStudio –data
  2. /Users/myUser/Documents/StudiWorkspace/SQLA

It brought up Teradata Studio again and started from new.  I ran a bunch of small queries and then imported the old history database.  It is still lagging.  I click on a cell and a couple seconds later it highlights, and same thing with scrolling, highlighting, etc.
The strange thing is, I don't see anything in the SQLA directory still.  It looks like they created a SQL directory, but there is never anything in it, even after closing.  ARe there just hidden files or something?

 

ssavoye 15 posts Joined 05/11
18 Mar 2016

Thanks Francine for your help.  I ended up uninstalling and reinstalling.  I believe something got messed up during the install.  I am not sure what happened, but at the time, I did not have Admin rights on my laptop/Mac.  My install was done remotely over VPN and Webex, and I am not sure if some configuration files or Workspace files may have been set for a shared drive or something.
It is early yet, but Studio is responding much better now and the issue seems to have gone away.  I do need to use it longer to be sure, but that will come.  I increased the parameters in the .ini file as well.  It may be a good idea to document that process of unlocking the directory and files on the Mac Finder and updating the file.  This is definitely not intuitive on the Mac.
Thanks again!  I will let you know if things go awry. 

fgrimmer 553 posts Joined 04/09
10 May 2016

As an update to the issue for Mac slow down related to the SQL History. We think we have isolated the problem to an issue with Mac OSx Eclipse SWT library when trying to display large text in the cell of the SQL History. Two columns that can have very large text values are the Results column and SQL Statements column. Studio currently allows the full result text to be displayed in the Results cell and a maximum of 1000 characters in the SQL Statements column. When you hover over the cell, it displays a text window with the text. We have changed this to use a default value of 150 characters. You can still see the full text value of the Results cell by double clicking on the Results cell in the SQL History. We have added a SQL History preference called 'Maximum Display Text Length' that you can change to increase this value. Again, 150 characters is the default. This fix will be available in the upcoming Studio/Studio Express 15.11 release.

mullasci 9 posts Joined 06/09
11 May 2016

There it is already a planned release date for TDStudio 15.11?

fgrimmer 553 posts Joined 04/09
11 May 2016

Yes. It is planned for release at the end of this month.

jessielin 5 posts Joined 07/12
23 May 2016

I notice a similar issue on Windows. After the sql history has accumated after a certain threadhold, the sql editor becomes very slow.
I found that if I check "Automaticaly clean up result history" under Preference/Data management/SQL Development/SQL Results View Options/History Options. And when it gets slow, I close Studio and Reopen it, and SQL Editor's performance is back to normal. It seems now that the sql history tab has a bit over 2000 record when I reopen Studio.

sfought 5 posts Joined 10/14
02 Jun 2016

Could you share the release date of 15.11?  Thanks.

fgrimmer 553 posts Joined 04/09
03 Jun 2016

Studio 15.11 is now available on the Developer Exchange Download Site.

You must sign in to leave a comment.