>Nadya,
>
>What kind of file is the result file? How and when do you put the data to the result file?
>
Originally I put data in the result text file once the whole process finished. I also show this result file in the form Statistics, but I think, I should not do so.
I like Sergey's idea. Stupid me to not think of it :)
>If the result file is a table (with a memo field), why can't you put the changes there as they happen?
>
>>For each record I keep some notes about what changes were done. I also want to keep the history of the whole file, so I need accumulative notes, which I then send to a result file.
>>
>>Originally I just created a form's property to keep accumulative notes.
>>I never ran my tests on 600000+ rec. file, but my manager did and found a serious slow down.
>>
>
>I don't really understand what you were doing. Hopefully the answers to the above questions will help...
>
>
>>So, I got rid of this form property, I now create a temp cursor in the Init of the class curNotes (Notes M)
>>
>>and do replace Notes with NotesStr additive.
>>
If it's not broken, fix it until it is.
My Blog