# rows that match filter not shown when over 1,000

RevitArkitek's profile image RevitArkitek posted 5 years ago in General Permalink

If I apply a filter and the number is less than 1,000 the text indicates how many rows match the filter, but if it returns more than 1,000 it does not show the total number that match the filter. Is there any way to fix this? I understand that showing more than 1,000 rows typically is undesirable for performance reasons but I'd like to know how many match still.

ansgar's profile image ansgar posted 5 years ago Permalink

The data grid is by default limited to 1000 rows, so if your filter matches more than 1000, HeidiSQL cannot yet tell you how many rows would match. But you can increase these 1000 rows, in Tools > Preferences > Grid formatting.

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