Results 1 to 3 of 3
  1. #1
    BRZ-Ryan is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2013

    Best practice for data storage in db

    My company monitors phone call stats for each agent that we have. Per month, there are approx 3600 records (9 categories * 400 agents) containing about 4 different fields that are imported into a spreadsheet with a VBA macro that I wrote. I also wrote a macro that averages these 9 categories into an average so I end up with just 400 records (the averages) that I actually need in the database.

    I currently import all call data into a spreadsheet, do average calculations, then export averages to my Access database. I was thinking of placing all data into the database directly instead of doing all of the work in a spreadsheet first.

    Do databases begin to run slower as they get larger? My concern with doing this is having 3600 additional records per month. I do like being able to exclude the spreadsheet from this process, though.

    Any info\advice is appreciated

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    Yes, queries, forms, reports can perform slower with large datasets, especially if passing data over network and the objects have complex structure. Speed of network is also a factor.
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Assuming a Win 7 machine with at least 4G RAM; 3600 records/month you won't see any speed problems for a decade..... Your hunch to eliminate the excel sheet step is a good one. I don't think you will have any problem.

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

Similar Threads

  1. Replies: 2
    Last Post: 01-02-2015, 05:30 AM
  2. SQL Storage within a table
    By Kinetic in forum Queries
    Replies: 2
    Last Post: 11-20-2012, 09:06 AM
  3. Fields of Data! A best practice question
    By AlexSalvadori in forum Database Design
    Replies: 1
    Last Post: 11-08-2012, 12:37 PM
  4. Best practice?
    By thekruser in forum Queries
    Replies: 2
    Last Post: 09-20-2010, 09:41 AM
  5. PDF Storage
    By slash75 in forum Access
    Replies: 0
    Last Post: 04-18-2007, 02:51 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
Other Forums: Microsoft Office Forums