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

RevitArkitek posted 1 month ago in General

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 posted 1 month ago

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.