How to open large MySQL files - SCiTE

I've long had this issue not being able to open large files, typically MySQL files.

Applications bundled with Windows, such as notepad and wordpad just don't cut it - I think because they read the entire file to memory before opening.

Then I found Scintilla's SCiTE.. WOW! I downloaded the file for Windows, unzipped it and opened a 246mb MySQL file in seconds.

Very impressive stuff! And as I was so impressed, I decided to take a tour and found that it supports syntax highlighting in all the popular programming languages, as well as many I've never before heard of. It even has code collapsing as standard.

And just in case you are having trouble moving a large MySQL file, take a look at my answer on the next post!