Alpha DevCon 2018
Results 1 to 6 of 6

Thread: Maintaining optimized applications

  1. #1
    "Certified" Alphaholic
    Real Name
    William Hanigsberg
    Join Date
    Apr 2000
    Location
    Toronto, ON
    Posts
    4,018

    Default Maintaining optimized applications

    Hi all,

    I know I have read (but where?) that if you update indexes from a shadow the indexes to master tables are updated. But what happens if you open a shadow application and pack a table. Is the master table packed?

    Or do you need to open the server copy?

    Thanks,
    Bill
    Bill Hanigsberg

  2. #2
    "Certified" Alphaholic Scott Emerick's Avatar
    Real Name
    Scott Emerick
    Join Date
    Dec 2000
    Location
    Central Virginia/ North Carolina Border
    Posts
    2,154

    Default

    Hi Bill,

    Since a shadow database uses the Master copy tables, it is assumed that ANY operation done to the tables will be done on the server since thats where the table reside.

    Scott

  3. #3
    "Certified" Alphaholic
    Real Name
    William Hanigsberg
    Join Date
    Apr 2000
    Location
    Toronto, ON
    Posts
    4,018

    Default

    Hi there,

    That's what I think but it would be a comfort to see it in the documentation.
    Bill Hanigsberg

  4. #4
    Alpha Software Employee Lenny Forziati's Avatar
    Real Name
    Lenny Forziati
    Join Date
    Nov 2001
    Location
    Alpha Software
    Posts
    4,640

    Default

    Quote Originally Posted by whanigsberg
    Hi there,

    That's what I think but it would be a comfort to see it in the documentation.
    Have you sent Ed an email?

  5. #5
    "Certified" Alphaholic
    Real Name
    William Hanigsberg
    Join Date
    Apr 2000
    Location
    Toronto, ON
    Posts
    4,018

    Default

    Yes, I have.
    Bill Hanigsberg

  6. #6
    "Certified" Alphaholic
    Real Name
    Cal Locklin
    Join Date
    Mar 2000
    Location
    S.E. Michigan
    Posts
    5,761

    Default

    I'm not sure what the <TBL>.UPDATE_PRODUCTION_INDEX() function will do because I seldom use it. However, my experience was that a table opened and rebuilt in a shadowed database as simply:

    tp = table.open( "TableName" )
    tp.index_create_begin( "....." )
    tp.index_add( "....." )
    tp.index_create_end()

    will put the index on the LOCAL computer.

    If you try to do this, make sure you open the server table with something like this:
    Code:
    DIM datapath as C
    IF a5.Get_Master_Path() = ""
       datapath = a5.Get_Path() + chr(92)
    ELSE
       datapath = a5.Get_Master_Path() + chr(92)
    END IF
    tp = table.open( datapath + "TableName" )
    In case you are wondering why I never update indexes, it's because of my AIMS Index Rebuild function (yes, another shameless plug) which is a 'developer' function that reads all existing indexes and actually builds another function which is automatically stored in the application to rebuild those indexes to the exact definition as originally defined. The rebuild is just as fast as an update and it guarantees me that every index I need will be there when it's done. This is useful if an index is lost or if it's removed by either an overzealous developer (that's you - I certainly would never do something like that) or your user. The function can also be used to automatically force an index (or indexes) to update before critical operations.

    Cal Locklin
    www.aimsdc.net

Similar Threads

  1. Maintaining an A5 table from Visual Basic.NET
    By Marcel Kollenaar in forum Alpha Five Version 6
    Replies: 5
    Last Post: 12-20-2004, 02:59 AM
  2. Auto-increment on an optimized system
    By dparkins in forum Alpha Five Version 5
    Replies: 5
    Last Post: 04-06-2004, 04:55 PM
  3. Mexican needs help with Network Optimized
    By Mario Prieto in forum Alpha Five Version 5
    Replies: 5
    Last Post: 10-27-2002, 06:28 PM
  4. Modifying queries to run optimized
    By whanigsberg in forum Alpha Five Version 4
    Replies: 25
    Last Post: 06-25-2002, 05:32 PM
  5. Optimized Network
    By Thomas Henkel in forum Alpha Five Version 4
    Replies: 23
    Last Post: 05-25-2001, 03:01 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
  •