It's the same search I've worked on before which is for the items wo transaction movement, the search got slower and slower as more columns is being requested to be shown in the results. more joins and stuff