Hi,

I am writing an application that will be storing 10's of thousands of records. I am wondering what would be faster in terms of searching for records, using serialization or using an Access 2000 database?

I know that access 2000 sucks and that is why I am thinking of using object serialization to store my records versus an access 2000 database. My database structure is very simple and there is no relational data at all.

The only thing I am worried about is the record searching. If I have 40,000 records in a CObject array and have to loop through the array to find the record with a MediaID of 3564, would that be just as quick as a "SELECT MediaID FROM tblMedia WHERE MediaID = 3546" ?

If so I will use serialization instead.

Any thoughts or guidence on this would be much appreciated! Thanks