Hi.

I have a problem with the History Item Button, its very slow and i was wondering if its posible to modify the query that executes.

But i found that is a View, i haver searched in the database and the process, even i opened the profiler tool and i couldn't get the query that executes.

There is a way that i can improbe the speed that that view works?

Thanks.

How many million History records are we talking? When did you develop and execute an archiving strategy for the database change records from X years ago?

Are the ID fields that are set to Blank actually set to NULL?

Run the SLX Profiler.exe program when analyzing performance......C:\Program Files\SalesLogix

The History tab 'views' are editable, customizable, and you can log log the SQL being executed.....