Sublime Text 3 Performance Tips

Photo by Sasha via Unsplash (cropped) | Sublime Text 3 Logo by Mauricio Wolff

Sometimes when I’m opening a really large .sql file, Sublime Text 3 will just crash with no warning. It loads roughly 15% of the file and then just closes unexpectedly.

From what I’ve read on the Sublime Text forum, it’s likely due to the processing it takes to perform syntax highlighting on the file.

Unfortunately, some of the methods described in these cannot solve the issue of turning syntax highlighting off prior to opening the file. Mostly all of them suggest opening the file(s) you want to work on, then navigate to View > Syntax > Open all with current extension as... and then select the syntax you prefer.

So the easiest workaround I found for opening a large file was to change the extension from .sql to .txt. This forces it to set the syntax highlighting to Plain Text.