Check this link
http://www.experts-exchang
It might come for some help, they had a similar problem
Main Topics
Browse All TopicsClassic ASP, Response.Flush not working properly.
I have built a script that takes data from database [a] to database [b].
Throughout the process i flush the array i am using to clean it out, unfortunatly the system doesnt seem
to be clearing it out so memory is getting clogged up.
Does anyone have any ideas as to why this is happening, i have enabled buffereing in IIS, and added loads of debug messages but cant figure it out.
Any help would be much appreciated.
Many Thanks in advance
Damian
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Check this link
http://www.experts-exchang
It might come for some help, they had a similar problem
As bugs states, response.flush wipes out the response buffer and sends it to the client.
When you say "Throughout the process i flush the array i am using to clean it out, unfortunatly the system doesnt seem to be clearing it out so memory is getting clogged up."
Are you expecting the flush to clear out your arrays? If so it won't work as that's not what it does.
I assume that you are loading data from DB A into an array and then writing the array to DB B. Then clearing out the arrays then repeating the process until all is done. Is this correct?
If so I don't see how response.flush can help.
It's normally used for particularly 'large' pages where you can throw something at the user to let them know things are still happening.
If it is your response buffer that is clogging up then response.flush should help - but it won't help your arrays.
If you don't expect it to flush your arrays then sorry, just misunderstood what you said :)
Business Accounts
Answer for Membership
by: bugsPosted on 2007-07-03 at 04:48:20ID: 19410275
Response.flush method sends buffered output immediately. If you use this, don't forget to set Response.Buffer = True.
Set
<%Response.Buffer = True%> as the first line in your ASP page