Just recently moved from a windows machine with sql assistant to a mac with studio express, and I'm running into some issues with studio express:
Any thoughts on whether there's either a) another option for mac for just submitting "end-user" queries - insert/update/select/etc., or b) some sets of options that I can set up in studio express to performance-tune it to limit the lagginess? The keypress lag is particularly difficult to work around.
On my system this was mainly related to low memory assigned to Java.
There's a TeradataStudio.ini file within the app folder:
Try increasing minimum and maximum memory, my settings are
This definitely seems to help. Any idea what the below setting is, and should it be changed to 2048 as well?
Adam, MaxPermSize refers to the size needed by the permanent generation of objects in the VM (Class names, internalized strings, objects that will never get garbage-collected). If you see
java.lang.OutOfMemoryError: PermGen space errors, you need to increase the permanent generation space available to Studio.
Hi. When I open the terdataStudioExpress.ini file in TextEdit on Mac, I'm able to see the text but when I try to edit the setting I get this warning;
"You don’t own the file “TeradataStudioExpress.ini” and don’t have permission to write to it."
Any advice on how i can change these settings?
@egillen, The TeradataStudioExpress.ini is located in the install directory. You will need admin privileges to modify it.
Hi Francine, I've been able to carry out the update and i've already seen a performance improvement. :-)
I'm just wondering, how high can I update these memory settings... is there a point of diminishing returns?
@egillen, You can increase the memory arguments in the .ini file. The current settings are at 512m:
I had the same problem. I switched off all the syntax checking and it was still slow.
Closing studio and restarting it did the job. (Apparently, even though you change the settings, the program needs to be closed and reopened before the new settings take effect.