ATL collection using database
Posted on 2001-07-12
I have implemented a collection in ATL.
"People" is the collection "Man" is an item of the collection.
In the database i have a table People and so, each record in the table is a Man.
I use ADO to access my database.
And my ATL collection have to support multithread.
On each item of the collection, you can Set and Get properties.
The problem i have is on how i get the data of my items. I can't store the data directly in the "Man" object because if another client have changeed the name for instance, the state of my object will be incorrect for other clients.
So, i have to get the data in the database each time the client access a property of an item. And it disturbs me a lot because it implies each item to have a recordset, to go and get the data in the database.
So 70000 items --> 70000 recordsets, i think it is not acceptable.
So my question is, what is the current and efficient way to implement a collection that manages table of a database?