Alpha Video Training
Results 1 to 2 of 2

Thread: Quick Question.

  1. #1
    Jamin Dunivan
    Guest

    Default Quick Question.

    Just trying to confirm what I believe to be true. When you are running from a shadow database, the indexes are actually local to that computer. Meaning that you could corrupt the shadow indexes on one machine and the other computers would still be alright.

    This seems to have happened to an app here. One computer worked fine the other was really messed up until I rebuilt the indexes.

    Jamin

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,311

    Default RE: Quick Question.

    Jamin,

    a quick answer --> no.

    When you create a shadow folder on the local workstation using Network Optimize the 'actual' data remains on the 'server'. This includes the DBF, CDX and FPT files.

    Shadow copies of your tables are copied to the shadow folder on the local workstation during network optimize. These do not contain your data. They are empty except for pointers which tell Alpha Five where the actual data is stored on your server.

    So, if you open the database using the local shadow copy of the ADB, all of your changes, including reindexing, are stored on the server.

    A complicating factor here is that when you begin reindexing Alpha Five requires exclusive access to the tables. If anyone else on the network is working with the tables, the reindexing will not be successful. In my own work I try hard to have everyone on the network exit alpha five entirely, before beginning to rebuild the indexes.

    -- tom

Similar Threads

  1. quick question
    By BRIAN GRAY in forum Alpha Five Version 5
    Replies: 1
    Last Post: 04-15-2005, 11:03 PM
  2. Another Quick Question
    By Rick Canady in forum Alpha Five Version 5
    Replies: 9
    Last Post: 01-27-2004, 04:24 AM
  3. quick question
    By dik_coleman in forum Alpha Five Version 5
    Replies: 14
    Last Post: 12-19-2003, 08:37 PM
  4. Quick Set Question
    By BRIAN GRAY in forum Alpha Five Version 5
    Replies: 2
    Last Post: 04-10-2003, 06:37 AM
  5. Quick - Quick Filter Question
    By forskare in forum Alpha Five Version 4
    Replies: 2
    Last Post: 05-08-2001, 10:08 AM

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
  •