Results 1 to 3 of 3

Working with A Lot of Data...Ideas Needed

  1. #1
    tanyalee123 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2013
    Posts
    51

    Working with A Lot of Data...Ideas Needed

    Happy Friday!


    So I've designed a database, but my oh my it's so slow! The purpose of the database is a healthy pregnancy program. I have to load thousands of eligible women into the database so that the employee can then find the women who will be in the program. So basically, the user doesn't have to input a bunch of data about the women in the program; it's all there for her already.

    With thousands of records, the database runs so slow because of course it runs through all of the records whenever a query is run, etc. How do I create it so that there is a table for the thousands...most of which are not needed...but when she "chooses" a record of a woman who will participate in the program, that woman's record gets put into a table of "Participants". This way, when I create queries or reports for her, they will only have to be run against the few hundred that she is working with. Any ideas?

    OH and FYI...I will likely be splitting this database, so the table with the thousands could be in the BE and the table of "Participants" could be in the front end.

    Thank you!!

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,335
    Do you have indexes on some fields in your table(s)? Can you tell us about your database -- tables and relationships?
    It would be helpful if you could tell us more about "the business". Your database is intended to support some activities and processes (the business).
    When you split an Access database into FE and BE, the tables (data) go in the BE and the queries, forms,reports go in the FE.
    Good luck with your project.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,365
    It is slow running queries? Thousands is a small db. I have over 60,000 records in one table and queries run fine. Access is capable of millions of records.

    Duplicating the participant's data into another table is not optimal design and that table should be in the backend anyway, unless it is a 'temp' table. Temp table is table that temporarily holds records for a process. The records are purged before the process runs.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. trim data as needed
    By rkalapura in forum Access
    Replies: 3
    Last Post: 11-25-2012, 09:54 PM
  2. Replies: 1
    Last Post: 11-21-2011, 01:09 AM
  3. Replies: 3
    Last Post: 10-14-2011, 08:52 AM
  4. avg/min/max data help needed badly
    By donavan01 in forum Access
    Replies: 7
    Last Post: 02-13-2011, 12:49 PM
  5. Replies: 0
    Last Post: 09-07-2009, 04:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums