Base on condition that we have one database and lot of sites in auditlog table we have field KeyValue which contain the site name but with changed value (ex. V000945-1-MASTER) and searching with LIKE condition is very difficult and time consuming.
However, relying on the 'KeyValue' column with a LIKE condition in SQL queries is not optimal from a performance standpoint. Searching with LIKE can be significantly slower, especially as the AuditLog table grows over time and it is much bigger and bigger.
It would be much more efficient to have a dedicated site_ref field in the AuditLog table. This would allow us to create an index on that column, which would greatly improve query performance and scalability. Having a separate field also simplifies filtering and reporting.
Business Impact
It would greatly improve query performance and scalability, additional it will range the searching via form, now we can view via form all entries from all sites.
