memo or characterfields ?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: memo or characterfields ?

  1. #1
    Shanice Guest

    memo or characterfields ?


    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

  2. #2
    Craig Berntson Guest

    Re: memo or characterfields ?

    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




  3. #3
    Cindy Winegarden Guest

    Re: memo or characterfields ?

    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

    >
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center