What happens when we forget to close recordset in web page?

Kiran S S

Hi Everybody, I am working with classic ASP. In one of my webpage i forgot to close a recordset. This recordset contains good amount of data. And I found this mistake very late. I have currected it. But I still want to 1) Is it affects on site speed? 2) How dose such mistakes affects Websites? What are the effects of such mistakes? Kiran Sajanikar.

Michael Sync

Kiran S. S. wrote:

Is it affects on site speed?

If you open tooo much of connection then it will affect on site speed. But the GC will clear the object that are no longer used for a particular time.

Kiran S. S. wrote:

How dose such mistakes affects Websites? What are the effects of such mistakes?

Opening a lot of connections makes your server tired.

Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)

N a v a n e e t h

Michael Sync wrote:

But the GC will clear the object that are no longer used for a particular time.

He is saying about classic ASP not .NET. GC won't be available there.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions

N a v a n e e t h

Kiran S. S. wrote:

How dose such mistakes affects Websites? What are the effects of such mistakes?

I guess the connection will be open. This may cause timeout errors if more number of concurrent requests are coming.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions

Kiran S S

In that page i have used two recordsets. One recordset and connection i have closed carefully. But i forgot to close that remained recordset.

Kiran Sajanikar Software Engineer CleverBIT softwares. Pune.

Michael Sync

N a v a n e e t h wrote:

classic ASP

Oh. I didn't notice.. I thought he is using ADODB in .NET. ya.. thanks.

Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)

Kiran S S

So What are effects in such cases?

Kiran Sajanikar Software Engineer CleverBIT softwares. Pune.