Please, answer today...Speed Problem with Database

<i><b>Originally posted by : Mike (michelricard@hotmail.com)</b></i><br /><br />Is there a time limit for opening or closing a connection because :<br /><br /> Opening a page that has to call my Database takes like 15 seconds on a T-1.<br /><br />Then if I'm calling another page right after, it takes not even 2 seconds.<br /><br />Butif I wait like 5 minutes and try to call another page then it takes quite a long time again.<br /><br />I don't get it !!!!<br />What am I missing<br /><br />Here is the code<br /><br /><%<br />set rsItemsList = server.createobject("adodb.recordset") <br /><br /> strconn = "DRIVER=Pervasive System Software ODBC-32"<br /> set conn = server.createobject("adodb.connection")<br /> conn.open "DSN=Cadet"<br /><br /><br />%><br />sqlItemsList = "Sql String"<br /> rsItemsList.open sqlItemsList, conn<br />%><br /><br />.....<%=rsItemsList("something")%><br /><br /><%<br /> set rsItemsList= nothing <br /><br /> conn.close<br /> set conn = nothing<br />%><br /><br /><br />Thanks a lot !!!!!<br />