This was fixed in 2091.
The SQL grammar file had a degenerate regex that could cause significant slowdowns.
I agree, even files of about 5000 lines start to slow down considerably.
5000 line files are, in general, handled fine. Check what plugins you have installed - several can cause severe slow downs.
Loading a 94meg SQL file can take upwards of 10 minutes on a reasonably powerful laptop. I'd like to see some sort of memory paging implemented.
I'd like to see the option that would turn off syntax highlights automatically when opening files over a specified size, identical to the already present "auto_complete_size_limit" option.
It would speed up the process by a LOT, and I assume it would be trivial to implement.
I'd like to see this feature to open +800mb SQL files in seconds like I already do with gVim
This is basically the same request as the: "Use memory mapped files for opening and viewing large files (e.g. 1GB+)"
Would be very useful for a lot of people who are working with large files. (or course the search function need to be tweaked for this)