Home All Groups Group Topic Archive Search About

Alternative to Dataset??

Author
13 Jun 2006 4:03 PM
Amar
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.

Author
13 Jun 2006 9:00 PM
John Timney (MVP)
"Amar" <amarjeetlokha***@gmail.com> wrote in message
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?

Yes, leave it in the database and get it when required.

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
> 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.

You could store a subset, or the whole dataset as a local XML file,
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)

AddThis Social Bookmark Button