×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
A lot depends on what's going to read and write the data. On the
surface, this sounds like a good use for a CLOB (or large variable
length fields) to store the notes but if RPG/400 programs are going to
use the data, you can't use them (CLOBs) and large fixed length fields
would be better.
Matt
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of tim
Sent: Thursday, August 09, 2007 9:57 AM
To: Rpg Forumn
Subject: Database design question
Hello all,
I have to design a database that will hold notes keyed by a user. These
notes can be anywhere from a few words to a several hundred. Notes will
be
tracked by user/date/time. There can be hundreds of separate notes
entered
each day, so this database will get rather large.
As far as defining the actual field that will hold the note. I would
like
some design feedback. Should it be fixed, variable, other.
Thanks for all the input in advance.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
