Get a Jumpstart with our Sample Apps
Results 1 to 3 of 3

Thread: Time it takes to Recalculating field rules

  1. #1
    Member
    Real Name
    Robert Okrzynski
    Join Date
    May 2000
    Posts
    109

    Default Time it takes to Recalculating field rules

    I am transitioning from Alpha 4 to Alpha 5 v9 Platinum. I have a database of about 35,000 records and 63 fields. The data resides on our server and the alpha 5 program is installed on a desktop. After getting the data into Alpha 5, I have added field rules and want to recalculate the field rules. This process takes about 30 to 45 minutes to complete.

    Would performance be improved if I loaded the Aplha 5v9 software on the server?

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

    Default Re: Time it takes to Recalculating field rules

    I would say yes as any calculated fields over a network is inherently slow--I have found that on a standard 10/100 lan, what takes a couple of seconds on the desktop would take 3-4 minutes over the network. A gig network card would help also of course.....
    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
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,298

    Default Re: Time it takes to Recalculating field rules

    Robert, network optimizing the local workstation would help, too. Depending upon what your field rules do you might use a saved update operation more efficiently. i.e. disable the field rule, run the update operation, then enable the field rule for new records.

Similar Threads

  1. recalculating field rules for character field
    By Rokrz in forum Alpha Five Version 8
    Replies: 1
    Last Post: 10-10-2008, 05:59 PM
  2. current time in a field using field rules
    By gmeredith17 in forum Alpha Five Version 7
    Replies: 10
    Last Post: 01-31-2007, 11:51 AM
  3. Recalculating rules calc fields help.
    By flucky07 in forum Alpha Five Version 7
    Replies: 2
    Last Post: 11-30-2006, 12:42 PM
  4. Takes long time to save a transaction
    By Marlene Brusko in forum Alpha Five Version 5
    Replies: 5
    Last Post: 12-11-2004, 04:05 PM
  5. Recalculating field posting rules
    By Cheryl Lemire in forum Alpha Five Version 5
    Replies: 12
    Last Post: 08-05-2003, 07:57 AM

Posting Permissions

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