REVMEDIA FKB Articles - AREV, OI, REV G, jREV, JCDC, LIVEWATER,ADVANCED REVELATION, OPENINSIGHT, REVELATION G

RevMedia FKB

Document	V3I2A1
Title	Index Flush
Keywords	INDEX.FLUSH FILE.DISTRIBUTOR INDEX !INDEXING FLUSH
Text	The ability to update INDEXES FROM within a program is provided by a system subroutine called INDEX FLUSH This routine takes two parameters the file information and the index information USING this routine it is possible to update All INDEXES Pass "" "" All INDEXES for a file Pass File_Info "" An index for a file Pass File_Info Index_Info There have been REPORTS that this routine does not work as documented but this appears to stem FROM a misunderstanding of how the routine works Regardless of how the routine is called the same system routine (FILE DISTRIBUTOR) is called to clear !INDEXING This routine does not check to see which index it has been asked to distribute to the ! files it just moves all TRANSACTION records to the appropriate ! files clearing down !INDEXING as it does so Thus regardless of which mode is used the !INDEXING file will always be clear (assuming all relevant files are attached) AFTER an INDEX FLUSH call If a request was made to update a specific file all other ! files would have transactions left pending in records 0 1 2 etc If a request was made to update a specific index all other ! files would have transactions left pending in records 0 1 2 etc and the main ! file would have other index transactions pending in records 0 1 2 etc Note that because of this if there are a large amount of index transactions pending there can be a considerable delay when INDEX FLUSH is called even if none of the pending transactions are for the nominated file/index Contrary to the documentation it is possible to just pass the name of a file to INDEX FLUSH (rather than the complete FILEACCOUNTMEDIA_NAME) and it will then resolve the rest of the information itself This removes the need for additional code at the application level It is however important to ensure that the file you wish to flush WITH this command is the currently attached one (Volume 3 Issue 2 Page 4)

[revmedia/copyrigh.htm]

Page last modified: 08/02/03