Print Thread
Page 2 of 2 1 2
Re: Poor performance vs Oracle SQL Developer
koja #57978 05/24/18 01:20 PM
Joined: Jan 2017
Posts: 6
Athens, Greece
N
Member
Offline
Member
N
Joined: Jan 2017
Posts: 6
Athens, Greece
[quote=koja]
2) made sure nls_sort from backend and client matched(registry - Oracle home) [/quote]

NLS_SORT according to Oracle Documentation

"NLS_SORT specifies the collating sequence for ORDER BY queries."

Nothing to do with any kind of client performance.

Re: Poor performance vs Oracle SQL Developer
Nick Panoussis #58067 06/19/18 07:19 AM
Joined: Sep 2008
Posts: 34
C
Member
Offline
Member
C
Joined: Sep 2008
Posts: 34
Performance is definitely the issue, we all knows that, but despite of that is PLSQL Developer one of the best tool of the market, so, we have to try keep calm everytime hellish delay happens smile (and some days its pretty often smile
In my opinion problems are related to connection handling, multiple connections are more "addition" than integral part of application (why is there some "main" connection?). The hell comes when you try to use more connection at the same time and some of them are not available (eg you discconnect the vpn...) even if you tell the developper to close the connection, it sometimes "try" (=at least 30sec timeout) smile .. Another problem is poor tuning of system/dba queries (to get the oracle catalog data), you can try the checkbox "use DBA Views if avaliable" but it doesnt help much.
But as I wrote, for developer there isnt something really better smile

Re: Poor performance vs Oracle SQL Developer
Worker #58130 07/10/18 04:25 PM
Joined: Sep 2004
Posts: 495
Dartmouth College, Hanover, NH...
Member
Offline
Member
Joined: Sep 2004
Posts: 495
Dartmouth College, Hanover, NH...
Worker,

Thanks for your tip:

[quote]Turn off Preferences->Connection->Store recent history[/quote]
That worked nicely for me.

- Stew

Page 2 of 2 1 2

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.098s Queries: 16 (0.028s) Memory: 2.5241 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-04-30 11:38:03 UTC
Valid HTML 5 and Valid CSS