Reset HeidiSQL data view filters and sorting

posted on 10:39 AM on Thursday 09 October 2014

I use HeidiSQL for working with MySQL on Windows and it has been great. Recently I ran into an issue where I have this insanely large table (2.4 billion rows) which I had a much smaller version previous for testing. And during that testing phase, I sorted the data view on a column. However when all 2.4 billion rows were loaded, the sorting setting was still there and this causes HeidiSQL to hang as it was waiting for MySQL to sort on 2.4 billion rows. This effectively made it impossible to view the data for that table. A quick google reveal a way to remove the remembered settings from the registry.