Efficient non-db storage?

What's the most efficient way to store small messages
(similar in size to a short email) on the client without
using a database?

I need to be able to store thousands possibly. I was
thinking of C# classes serialized to XML? How efficient
would this be and what other alternatives are there?

Thanks in advance!.

re: Efficient non-db storage?

Efficient in what way? Data storage size, insert/update performace, random
access performance, simplicity of programming, etc.

Saving XML data to and from ADO would be simple and flexable.

Inserting the reords to TAB Delimited format would conserve the most disk
space and can be bulk copied to SQL Server in the least amount of time.

"Mike O." <anonymous@discussions.microsoft.com> wrote in message
news:06c701c3af85$30606240$a001280a@phx.gbl...[color=blue]
> What's the most efficient way to store small messages
> (similar in size to a short email) on the client without
> using a database?
>
> I need to be able to store thousands possibly. I was
> thinking of C# classes serialized to XML? How efficient
> would this be and what other alternatives are there?
>
> Thanks in advance!.[/color]

re: Efficient non-db storage?

My primary concern is efficient reading speeds and
sorting. Data storage size is also a concern, but not at
the cost of speed.

I do not plan to attach this to any sort of database, so
importing ease isn't a concern.

Do you still think ADO/XML is the right solution?
[color=blue]
>-----Original Message-----
>Efficient in what way? Data storage size, insert/update[/color]
performace, random[color=blue]
>access performance, simplicity of programming, etc.
>
>Saving XML data to and from ADO would be simple and[/color]
flexable.[color=blue]
>
>Inserting the reords to TAB Delimited format would[/color]
conserve the most disk[color=blue]
>space and can be bulk copied to SQL Server in the least[/color]
amount of time.[color=blue]
>
>"Mike O." <anonymous@discussions.microsoft.com> wrote in[/color]
message[color=blue]
>news:06c701c3af85$30606240$a001280a@phx.gbl...[color=green]
>> What's the most efficient way to store small messages
>> (similar in size to a short email) on the client without
>> using a database?
>>
>> I need to be able to store thousands possibly. I was
>> thinking of C# classes serialized to XML? How efficient
>> would this be and what other alternatives are there?
>>
>> Thanks in advance!.[/color]
>
>
>.
>[/color]

re: Efficient non-db storage?

You can use the Datasets .WriteXML("FileNameandpath") and
ReadXML("FileNameAndPath") to do this. Once you have your datasets, you
won't ever know it didn't come from a 'Real' database.
"Mike O." <anonymous@discussions.microsoft.com> wrote in message
news:0d4301c3af8a$284f2910$a501280a@phx.gbl...[color=blue]
> My primary concern is efficient reading speeds and
> sorting. Data storage size is also a concern, but not at
> the cost of speed.
>
> I do not plan to attach this to any sort of database, so
> importing ease isn't a concern.
>
> Do you still think ADO/XML is the right solution?
>[color=green]
> >-----Original Message-----
> >Efficient in what way? Data storage size, insert/update[/color]
> performace, random[color=green]
> >access performance, simplicity of programming, etc.
> >
> >Saving XML data to and from ADO would be simple and[/color]
> flexable.[color=green]
> >
> >Inserting the reords to TAB Delimited format would[/color]
> conserve the most disk[color=green]
> >space and can be bulk copied to SQL Server in the least[/color]
> amount of time.[color=green]
> >
> >"Mike O." <anonymous@discussions.microsoft.com> wrote in[/color]
> message[color=green]
> >news:06c701c3af85$30606240$a001280a@phx.gbl...[color=darkred]
> >> What's the most efficient way to store small messages
> >> (similar in size to a short email) on the client without
> >> using a database?
> >>
> >> I need to be able to store thousands possibly. I was
> >> thinking of C# classes serialized to XML? How efficient
> >> would this be and what other alternatives are there?
> >>
> >> Thanks in advance!.[/color]
> >
> >
> >.
> >[/color][/color]

re: Efficient non-db storage?

i find the XmlSerialization classes you mentioned very useful for this kind
of thing. in addition, check out the System.IO.IsolatedStorage classes if
you're interested in 'wrapping up' your data with versioning info,
security, etc.

let me know if you have any questions about using these.

jeff.

--

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.

re: Efficient non-db storage?

Serialization could definitely work. Binary serialization should be more
efficient than XML serialization in terms of both file size and speed.


"Jeff Callahan" <JeffCal@online.microsoft.com> wrote in message
news:S0JrZa5rDHA.3644@cpmsftngxa07.phx.gbl...[color=blue]
> i find the XmlSerialization classes you mentioned very useful for this[/color]
kind[color=blue]
> of thing. in addition, check out the System.IO.IsolatedStorage classes if
> you're interested in 'wrapping up' your data with versioning info,
> security, etc.
>
> let me know if you have any questions about using these.
>
> jeff.
>
> --
>
> This posting is provided "AS IS" with no warranties, and confers no[/color]
rights.[color=blue]
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> Note: For the benefit of the community-at-large, all responses to this
> message are best directed to the newsgroup/thread from which they
> originated.
>[/color]

re: Efficient non-db storage?

Thanks everyone for all your help!!![color=blue]
>-----Original Message-----
>What's the most efficient way to store small messages
>(similar in size to a short email) on the client without
>using a database?
>
>I need to be able to store thousands possibly. I was
>thinking of C# classes serialized to XML? How efficient
>would this be and what other alternatives are there?
>
>Thanks in advance!.
>.
>[/color]