By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,200 Members | 1,640 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,200 IT Pros & Developers. It's quick & easy.

best format to store text

P: n/a
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
Jul 17 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
<ti*********@btopenworld.com> wrote in message
news:bo**********@sparta.btinternet.com...
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

Jul 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.