Hi Kevin,

Sorry for delay getting back. The view was using a linked SQL server and a queried a number of views on different servers. Problem has been resolved by writing a stored proc that is run in an overnight job to create a results table. The query on the results table from the 3rd party app returns results instantly which has kept the end users happy.

Thanks for your input (and the Tips of the Day)

Andy