When working with a Record Search index and a filter column, try to sort the records in the CSV file or in the SQL query by the column that is used as a filter. This helps to improve the performance especially when working with a larger number of records.