Quick Filter "More values ..." runs naive query over huge, unindexed column killing the client/server

Battlestar's profile image Battlestar posted 6 years ago in Feature discussion Permalink

Hi!

The quick filter menu pulls out the most popular values of a given column. This is handy on small (!) tables even when the column isn't indexed. On the other hand, this menu should be disabled when the table is large and/or the column is not indexed because this starts a query which runs literally forever. This causes HeidiSQL to freeze and in some cases we experienced problems with other clients (transaction locking, etc.).

Best regards

Benjamin

1 attachment(s):
  • 2017-11-15_12-00-18_Clipboard

Please login to leave a reply, or register at first.