notepad++ freeze on large SQL file with stored procedures running on Server 2022, no issue on Server 2019
-
I am running the latest version of Notepad++ x64 on Windows Server 2022, Version 8.8.1
I have a 3.5 MB SQL file that contains stored procedures.When I open the file, it loads without any issues.
However, when I try to scroll to the end of the file, or even when scrolling through the middle, the application freezes. I can see that the CPU usage goes up to 12%, but there are no issues with memory, threads, or tasks.When I open the same file on Windows Server 2019 x64, I experience no issues.
I have also tried restarting the server, but the problem persists.I cannot share the original file, as I do not want to expose its contents.
To test further, I asked ChatGPT to generate a simple SQL file of the same size. When I open that file, the issue does not occur.The SQL file have 98000 lines
So I try to use the go to option
if I go to line 10000
then 20000
then 30000
then 40000its is not freezing
if I press go to line 30000, it freeze
-
@Nachum-Shmilovitz
Do you have any plugins installed? A plugin might be responsible.It’s also possible that the SQL lexer is causing this slow performance. You can disable this lexer (removing all syntax highlighting) by selecting
Language -> None (Normal Text)from the Notepad++ main menu.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login