Deploying Your Application with Indexes (Performance)

If your OpenInsight application has indexes you may have problems deploying with indexes.  There are two possible workarounds to this problem.

Method 1:

1.    Remove your indexes prior to deploying your application.

2.    Rename the OENGINE.EXE in your runtime application OENGINE.BAK

3.    Copy OENGINE.EXE from your development system to the runtime system

4.    Open the application in development mode

5.    Build all the indexes in the Database Manager.

6.    Delete OENGINE.EXE and rename OENGINE.BAK OENGINE.EXE

Method 2 (if you have already deployed)

1.    Rename the OENGINE.EXE in your runtime application OENGINE.BAK

2.    Copy OENGINE.EXE from your development system to the runtime system

3.    Open the application in development mode

4.    Open the system editor

5.    Open the dictionary for the file which has indexes (i.e. dict.table)

6.    Edit the field that contains pointers for the indexes these are:

       for BTREE indexes: line 6 should be changed from a 1 to a 0

       for XREF indexes: delete the field that has the .XREF extension; line 22 should be cleared

       for Relational indexes: Change the 1 on line 25 to a 0; line 24 should be cleared; Edit the dictionary for the source file and clear line 23

7.    Delete the %PRTECT.SPEC% and %FIELDS% records.  This can be done in the EXEC line in the system editor with the following command: RUN DELETE_ROW "DICT.TABLENAME" , "%FIELDS%" , 0

8.    Detach and reattach the volume.  In a deployed application the data tables default to the DATA volume.  The commands for this are:  RUN DETACH_VOLUME'DATA' and RUN ATTACH_TABLE 'DATA'

9.    You can now rebuild the indexes in the Database Manager.

10. Delete OENGINE.EXE and rename OENGINE.BAK OENGINE.EXE

Your deployed application now has indexes.