Duplicate Images being created
I have a proram that extracts images from an Oracle database. I query on some data attributes and a blob column. If there are more than a 1000 images to extract an issues araises. The pattern is pretty constaint at 1000 good extracted images then the next 400 image written to the filesystem are a duplicate of the last good image to be extracted. Then next 100 images are fine again. The next 400 are dupes of the last good image form the 100. This pattern repeats. I have seen only one case were the pettern changed and the 400 dupelicate image were only 200. This issue happens on any computer we run from. I have 2gigs memory and a 1.5gig swap file. I feel this must be something to do with the ADO recordset or the Oracle connection. Something external of my code but can't figure it out. Could someonr take a look and give me some direction?
[852 byte] By [
blowery] at [2007-11-20 11:50:36]

# 2 Re: Duplicate Images being created
Set a breakpoint at 999 and step thru it. Kind of an odd error.
I had done this already with no new information to provide. No errors generated but when viewing the image that was created from the stream I still had the same duplication issue. Since this post I have been digging deeper and discovered that I have cachesize set to 500 which is a multiple of 1000 and 400+100. I removed the cache setting and increased it to 5000 and in both cases the duplication or creation of the wrong image ceased happening. Does anyone know of issues with using this cachesize attribute on an ADO recordset? Is it better off or on?