Performance enhancement for CDPOS search

Hi,

The requirement is a report of the history of changes to various fields(approximately 11 of them) for an equipment serial number selected by the user. The report has to search CDPOS with the equipment serial number and find all the changes to the various fields for the past few years. This is taking hours to output the result or the system times out. Has someone come across this issue. Please suggest if there is an efficient way to get this report or to read CDPOS.

Thanks!