you can read about it in the 15R4 upgrade ref. ftp://ftp-public.4d.fr/Documents/Products_Documentation/LastVersions/Line_15R4/VIntl/4D_Upgrade_v15_R4.pdf
p.62 > In 4D v15 R4, we have greatly optimized the algorithm for global reindexing > of a database. The whole process has been dramatically accelerated, and can > be up to two times faster. > > Note: A global reindexing is required, for example, after a database repair > or when the .4dindx file has been deleted. > > Since each record of each indexed table needs to be loaded in memory during > indexing, the optimization aimed at minimize disk swaps. This operation is > now performed on each table sequentially, which reduces record loading and > unloading operations. > > In a perfect scenario, the cache would be large enough to contain the whole > data file and index --- in this case there would be no speed improvement by > the new algorithm. However, the available server memory is usually not that > big. If the cache is large enough to hold at least the largest table and its > index(es), the new algorithm will be up to twice as fast as before. ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************