memo or characterfields ?

[Shanice]

Hi ,

I have a sort of dilemma , I have to create a free table. In the table I
have to put results of a test (300/test) . First I thought I would use
the following table

ID N(5) , Questionno N(3) , Answer C(1)

but because of the fast growing amount of records (3000 test / year = 3000x300
= 900000 records) I thought it would become slow to search in and the indexes
would come corrupt. Then I thought of using a memofield and create for each
test one record with in the memo the answers seperated with a seperator .

ID (N5) Answers M(10)

So i would reduce my record to 3000 / year .But I'm a bit worried about
using memo fields. Because in the past i had several problems with them (corrupt
, lost of content , ...)

Can anyone suggest me what to use.. or is there a more ingenious answer to
my question ?

Thx in advance

Shanice

[Craig Berntson]

I'd use your first idea. 900000 records is a piece of cake for VFP.

--
Craig Berntson
MCSD, Visual FoxPro MVP
www.craigberntson.com
Salt Lake City Fox User Group
www.slcfox.org
Visit FoxCentral www.foxcentral.net
---


"Shanice" <shanice26@hotmal.com> wrote in message
news:3c3ea4e0$1@147.208.176.211...
>
> Hi ,
>
> I have a sort of dilemma , I have to create a free table. In the table I
> have to put results of a test (300/test) . First I thought I would use
> the following table
>
> ID N(5) , Questionno N(3) , Answer C(1)
>
> but because of the fast growing amount of records (3000 test / year =
3000x300
> = 900000 records) I thought it would become slow to search in and the
indexes
> would come corrupt. Then I thought of using a memofield and create for
each
> test one record with in the memo the answers seperated with a seperator .
>
> ID (N5) Answers M(10)
>
> So i would reduce my record to 3000 / year .But I'm a bit worried about
> using memo fields. Because in the past i had several problems with them
(corrupt
> , lost of content , ...)
>
> Can anyone suggest me what to use.. or is there a more ingenious answer to
> my question ?
>
> Thx in advance
>
> Shanice

[Cindy Winegarden]

Shanise,

Craig has a good article on his website about preventing index corruption.

--

Cindy Winegarden MCSD, Microsoft MVP
cindy.winegarden@mvps.org http://cindywinegarden.adsl.duke.edu
http://msdn.microsoft.com/vfoxpro http://foxcentral.net


"Craig Berntson" <craig@craigberntson.com> wrote in message
news:3c3edf9a$1@147.208.176.211...
> I'd use your first idea. 900000 records is a piece of cake for VFP.
>
> --
> Craig Berntson
> MCSD, Visual FoxPro MVP
> www.craigberntson.com
> Salt Lake City Fox User Group
> www.slcfox.org
> Visit FoxCentral www.foxcentral.net
> ---
>
>
> "Shanice" <shanice26@hotmal.com> wrote in message
> news:3c3ea4e0$1@147.208.176.211...
> >
> > Hi ,
> >
> > I have a sort of dilemma , I have to create a free table. In the table I
> > have to put results of a test (300/test) . First I thought I would use
> > the following table
> >
> > ID N(5) , Questionno N(3) , Answer C(1)
> >
> > but because of the fast growing amount of records (3000 test / year =
> 3000x300
> > = 900000 records) I thought it would become slow to search in and the
> indexes
> > would come corrupt. Then I thought of using a memofield and create for
> each
> > test one record with in the memo the answers seperated with a seperator
..
> >
> > ID (N5) Answers M(10)
> >
> > So i would reduce my record to 3000 / year .But I'm a bit worried about
> > using memo fields. Because in the past i had several problems with them
> (corrupt
> > , lost of content , ...)
> >
> > Can anyone suggest me what to use.. or is there a more ingenious answer
to
> > my question ?
> >
> > Thx in advance
> >
> > Shanice
>
>