Question Database DAO Bloat

[midmented]

I've been researching into why I have so much bloat on my backend datasets. The 'non-bloated" size is 16mb while bloated is double (32mb) after a high user level day. I was wondering if anyone out there has reduced their bloat by using the Microsoft suggestion: http://support.microsoft.com/kb/289562

I am pondering on whether to look at all my code and make sure I've included it everywhere. Any suggestions or comments?

 

[RuralGuy]

Most developers will use the .Close method on a RecordSet as well as Set the RecordSet object to Nothing when they are done with it. Set RS = Nothing

 

[midmented]

I've been using the set rs = nothing not always using rs.close
Do you think it would decrease DAO bloat by a lot if I did include it?

 

[RuralGuy]

Couldn't hurt. I would get in the habit of using .Close each time you are done with your RecordSet.

 

[shadow9449]

Couldn't hurt. I would get in the habit of using .Close each time you are done with your RecordSet.

I just want to point out that in the article that was referenced, the rs was not set to nothing. I've always wondered if you need to do that if you close it. I do it just in case but it's interesting that the article doesn't show it.

SHADOW

 

[RuralGuy]

MS has taken the approach that the rs object is destroyed when it goes out of scope. Most MVP's contend that that is not always the case and therefore strongly recommend destroying the object when you are done and not rely on MS.