Hi All,<BR><BR>I am having a major problem with a huge database.<BR>My database has over 320 000 records in it and I need to show these records in a table in different ways, I have created a stored procedure that goes through all the records and brings me back details which I need but since the stored procedure takes over 1 1/2 minutes to run this is obviously to long to wait for the page to load.<BR><BR>What we have decided to do is at 1am every morning to run a certain page which creates all the pages required and populates them with the data.<BR><BR>The problem I am now having is that with this sp taking so long to run my connection is timing out? How do I go about sorting this problem out?<BR><BR>Thanks,<BR>GavinFor starters, can't you increase the ADO ConnectionTimeout?Yes I can, but yesterday I could not find out how but I have solved that problem now.<BR><BR>Thanks for the reply though 