notepad++ freeze on large SQL file with stored procedures running on Server 2022, no issue on Server 2019

Nachum Shmilovitz

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 40000

its is not freezing

if I press go to line 30000, it freeze

Mark Olson

@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.