Outlook collection taking 100x longer to delete than create

[bonkey]

Having a weird issue. I am loading in some data from a file it makes about 1.6 million records in a collection. (collection of class objects).

When I am all done and want to close the spreadsheet it takes over 30 minutes to close.

I tested it by setting all my in memory objects to nothing that the issue is in my giant collection.

It only takes a short time to read the file and build the collection list but setting that collection = nothing takes forever (over 30 mins).

Any ideas?

 

[bonkey]

Re: Collection taking 100x longer to delete than create

No it doesn't have any terminate code.

 

[bonkey]

Re: Collection taking 100x longer to delete than create

I added a timer and found that around 30,000 records it starts to take more time to delete than it does to create. I think this must just be a memory handling bug in excel.

 

[Norie]

Re: Collection taking 100x longer to delete than create

Probably a stupid question but, why are you reading all the records into a collection in Excel?

 

[bonkey]

Re: Collection taking 100x longer to delete than create

Its a file parser app. It is reading in the records to process. By putting them in a collection I can easily access the records later. It has never been an issue before.

 

[Norie]

Re: Collection taking 100x longer to delete than create

Do you need to store all of the records in the same collection simultaneously?

Actually, do you need to store them all in Excel?

Couldn't you read them in one by one, parse/process them, write the parsed data elsewhere?