Alpha Video Training
Results 1 to 3 of 3

Thread: Data Refresh time taking hours now

  1. #1
    Member
    Real Name
    Brad Lindsay
    Join Date
    Apr 2010
    Posts
    1

    Default Data Refresh time taking hours now

    Hi there, I've been using this for about 6 months (Reports are great!) but as the company file keep growing the refresh time has gone from minutes to hours. Am I right in thinking (sorry if this sounds daft) that everytime I refresh the data its taking an entire copy of the QB DB (now 60 meg) and dumping it into the passive tables. If so is there a way to just 'suck out' say the last week of data or can it look at the QB datafile and only bring over new/modified transactions?

    I have to run this report daily (basically invoice and credit reports in a special format) but its becoming unusable becasue of the delays - thanks for your help

    Brad

  2. #2
    "Certified" Alphaholic
    Real Name
    Mike Christensen
    Join Date
    Nov 2005
    Location
    Michigan U.P.
    Posts
    5,937

    Default Re: Data Refresh time taking hours now

    Brad,
    I understand your plight....and yes there are many things you can do to increase the speed of refreshing the passive linked tables.

    1. Only refresh the tables necessary (why do them all if not needed?)
    2. Limit the fields to only the necessary ones.
    3. Limit the data with either Where clauses or Arguments....date range, logicals (IsActive=.T. for example), a list of clients, etc.....
    4. There may be more ways given specific circumstances.....


    The free weekly webinar may or may not happen this Thursday, but something like this could be of benefit to you as we could demonstrate some of the above on request.

    Or private tutoring/mentoring perhaps if that would be of benefit....
    Mike
    __________________________________________
    It is only when we forget all our learning that we begin to know.
    It's not what you look at that matters, it's what you see.
    Henry David Thoreau
    __________________________________________




  3. #3
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,563

    Default Re: Data Refresh time taking hours now

    Mike is definitely right in his approach...

    We have clients with 4 gb QB company files that when the query is customized for efficiency, their refresh is minutes or seconds...

    I changed one a couple of weeks ago from 4 hours to less than 3 minutes with 1,000 records out of a huge QB file....
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

Similar Threads

  1. Date/time math & business hours
    By jwoloshin in forum Alpha Five Version 7
    Replies: 19
    Last Post: 02-27-2007, 10:24 AM
  2. Replies: 2
    Last Post: 06-05-2006, 06:58 AM
  3. Delete Taking Long Time
    By David Boomer in forum Alpha Five Version 5
    Replies: 6
    Last Post: 09-03-2003, 02:18 PM
  4. Time refresh
    By Humberto Rivera in forum Alpha Five Version 5
    Replies: 2
    Last Post: 01-05-2003, 03:58 PM

Bookmarks

Posting Permissions

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