Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    3

    Unanswered: too many records?

    I'm trying to create a database for research. Is 20,000,000 records way too many for access? Each record is only 16 characters (4 fields). What do people think?

  2. #2
    Join Date
    Nov 2003
    Posts
    4
    I suppose it depends on how you are planning on using this database. Could you give me more info ?

  3. #3
    Join Date
    Feb 2004
    Posts
    3
    Originally posted by Ruperto
    I suppose it depends on how you are planning on using this database. Could you give me more info ?
    It's for tracking sleep patterns. Basically, I will be measuring peoples activity while they are sleeping. Measurements will be taken every 30 seconds. The database will store these measurements. I will then create queries to compare the sleep activity of different people, and whether different conditions change sleep activity.

  4. #4
    Join Date
    Nov 2003
    Posts
    4
    20 000 000 is a LOT of records, even if they are only 16 bytes long. Perhaps SQL Server might be a viable alternative ? OR, is there any way that you can write this data to a text file instead ?

  5. #5
    Join Date
    Feb 2004
    Posts
    3
    Yeah, I think I'm going to look into some other options. Thanks for your advice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •