best format to store text

[Guest]

I am new to VB6 and need some advice...

I am developing software which aims to capture a text feed from a serial
port consisting of news stories in ASCII format and then save this text for
future editing. Each story is only a few paragraphs long - but each day the
news feed provides up to 100 stories. I had thought about saving each story
in an individual text file, or append each story into one large
random-access text file (eg one file per day), or lastly, I could use a
completely separate database.

The priorities are; allow multiple access to the same story over a network
for editing; carry out fast searches through large amounts of stored text;
use a reliable storage format which isn't prone to read/write errors or
corruption and; to use simple internal code and functions for accessing the
text. What do you reckon is the best format to store the text?

Regards
Tim

[Stephane Richard]

Re: best format to store text

If they are regula text files that don't go over 64Kb (roughly about 50
typewritten pages) in size (respectable for a mere story :-). You can save
it in a memo field in an Access database.

If they can get bigger than that, then singlefile approach would be better.
Remember that there's a file limit in the OS as in only so many file can be
created in a directory (folder). so at the worst I'd see about organizing
the stories in categories or something in that case.
--
Stéphane Richard


<tim.jones15@bt openworld.com> wrote in message
news:bojo5d$3ma $1@sparta.btint ernet.com...[color=blue]
> I am new to VB6 and need some advice...
>
> I am developing software which aims to capture a text feed from a serial
> port consisting of news stories in ASCII format and then save this text[/color]
for[color=blue]
> future editing. Each story is only a few paragraphs long - but each day[/color]
the[color=blue]
> news feed provides up to 100 stories. I had thought about saving each[/color]
story[color=blue]
> in an individual text file, or append each story into one large
> random-access text file (eg one file per day), or lastly, I could use a
> completely separate database.
>
> The priorities are; allow multiple access to the same story over a network
> for editing; carry out fast searches through large amounts of stored text;
> use a reliable storage format which isn't prone to read/write errors or
> corruption and; to use simple internal code and functions for accessing[/color]
the[color=blue]
> text. What do you reckon is the best format to store the text?
>
> Regards
> Tim
>
>[/color]