Patrick0809
Member
Hi all,
I am using Version 13 with the latest patch availabe. I have it since September/October 2019. I am very satisfied with it.
Previously I already used Toad or Oracle SQL Developer. SQL Developer has very limited options for my needs and Toad got really a lot of performance issues after some versions some years ago.
I have noticed increasing performance issues on my version of PL/SQL Developer 13.
Due to corona I am working mostly from home now, so I am using my private internet to connect to my company VPN.
My home internet speed is like ping < 10, download 80mbits+, upload 10mbits+
When I am in VPN I guess it is much slower, I haven't tested it yet.
Anyway I am connecting normally to any database, it works the same speed as when I am directly in the network localhost.
When I have opened ANY sql tab to edit any package from my computer then the problems started appearing after some time (Maybe some patches?). I start writing my package name or function or whatever and while typing it suddenly freezes for like 2 seconds, I guess it is trying to autocomplete something, but still very annoying. I havent found any option to disable this, as I would only like to use the F6 for autocomplete feature.
So to only use the editor when I am connected is a pain now.
Also sometimes when I autocomplete with F6 I have seen that it takes some time to load information (sure I know it is related to the connection) but sometimes it just freezes then. It shows me the autocomplete list for arguments for example but I can not choose anything and it just freezes. Taskmanager shows everything 0% usage and I have to kill the process. Also compiling some time freezes the PL/SQL Developer completely.
And when I switch tabs (I only use single db connection at a time) it is then also really slow to change the tab, as it seems to me it is reconnecting? I am not sure but this is not good for me. I can not even scroll then directly, because on developing packages I have more opened in other tabs to check code in between.
I am not sure if it is only based on connection speed, but one time I left this to complete whatever it is doing, but even after 5 minutes it didn't recover.
So what I would really need is to disable this autocomplete in general editor use. I only want to start it manually by F6. Maybe there is the option already, would be great if you can let me know where to find this option.
In general for me it seems in the beginning after installation it was much faster than now. Maybe there are files written and read somewhere which are getting bigger and slower after time?
Is there anything I can do about this autocomplete and this re-connecting after switching tabs?
PS: I am anyway thinking of getting version 14 soon, but I am not sure if it could get worse performance wise..
I am using Version 13 with the latest patch availabe. I have it since September/October 2019. I am very satisfied with it.
Previously I already used Toad or Oracle SQL Developer. SQL Developer has very limited options for my needs and Toad got really a lot of performance issues after some versions some years ago.
I have noticed increasing performance issues on my version of PL/SQL Developer 13.
Due to corona I am working mostly from home now, so I am using my private internet to connect to my company VPN.
My home internet speed is like ping < 10, download 80mbits+, upload 10mbits+
When I am in VPN I guess it is much slower, I haven't tested it yet.
Anyway I am connecting normally to any database, it works the same speed as when I am directly in the network localhost.
When I have opened ANY sql tab to edit any package from my computer then the problems started appearing after some time (Maybe some patches?). I start writing my package name or function or whatever and while typing it suddenly freezes for like 2 seconds, I guess it is trying to autocomplete something, but still very annoying. I havent found any option to disable this, as I would only like to use the F6 for autocomplete feature.
So to only use the editor when I am connected is a pain now.
Also sometimes when I autocomplete with F6 I have seen that it takes some time to load information (sure I know it is related to the connection) but sometimes it just freezes then. It shows me the autocomplete list for arguments for example but I can not choose anything and it just freezes. Taskmanager shows everything 0% usage and I have to kill the process. Also compiling some time freezes the PL/SQL Developer completely.
And when I switch tabs (I only use single db connection at a time) it is then also really slow to change the tab, as it seems to me it is reconnecting? I am not sure but this is not good for me. I can not even scroll then directly, because on developing packages I have more opened in other tabs to check code in between.
I am not sure if it is only based on connection speed, but one time I left this to complete whatever it is doing, but even after 5 minutes it didn't recover.
So what I would really need is to disable this autocomplete in general editor use. I only want to start it manually by F6. Maybe there is the option already, would be great if you can let me know where to find this option.
In general for me it seems in the beginning after installation it was much faster than now. Maybe there are files written and read somewhere which are getting bigger and slower after time?
Is there anything I can do about this autocomplete and this re-connecting after switching tabs?
PS: I am anyway thinking of getting version 14 soon, but I am not sure if it could get worse performance wise..
