I am faced with a challenge on my report page where I need to filter customers based on specific criteria and highlight certain details if their registration date falls after a specified date, such as 1st January 2011. With around 800 records to showcase, I am seeking advice on the most efficient approach for this task.
One option is to use client-side JavaScript to check and compare each record's registration date with the specified one, but this method may significantly slow down processing due to the high number of records.
Alternatively, I can implement a server-side scheduled script that sets a flag in the database to identify inaccurate records and change their display color accordingly. However, I am unsure how to make this scalable for other fields within the records.
UPDATE
Thank you for the helpful responses so far. To expand this feature to encompass all fields within the records, would it be feasible to store a separate flag for each field in a distinct table? This way, I could easily check which flags are set for each record and adjust the display accordingly.