|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Alternative to Dataset??Hi,
I am part of a team building a stock exchange software - Order Management system'. The current system that we have supports 200,000 orders per day. All of this data is needed in memory.Ofc ourse this system was built in VC++. what I want to know is : - Is there a alternative to storing data in dataset? - this alternative doesnt have to be as flexible and as feature filled as the dataset. -can you suggest some ideas for the same. I have been tinkering around with specifalised business objects and using them to store the data. "Amar" <amarjeetlokha***@gmail.com> wrote in message Yes, leave it in the database and get it when required.news:1150214600.998507.142040@g10g2000cwb.googlegroups.com... > Hi, > I am part of a team building a stock exchange software - Order > Management system'. > The current system that we have supports 200,000 orders per day. > All of this data is needed in memory.Ofc ourse this system was built in > VC++. > what I want to know is : > > - Is there a alternative to storing data in dataset? I would certainly not store large volumes of data in a dataset - techncially they should be transiant, holding data currently being worked on - or pointers to the data in the database for drill-down, and of course if you hold it there all day it could likely become invalidated as the status of orders change. That however is a design issue, but you should be looking at making use of things like cache invalidation against selected data and working on some traffic management and making correct use of the database this data sits within. > - this alternative doesnt have to be as flexible and as feature filled You could store a subset, or the whole dataset as a local XML file, > as the dataset. > -can you suggest some ideas for the same. > I have been tinkering around with specifalised business objects and > using them to store the data. depending on what your client is. Net has advanced classes for handling XML - that way its local but not resident in memory. -- Regards John Timney (MVP) |
|||||||||||||||||||||||