Hi, I guess our database of 120gb, running on a 32 bit machine doesn’t benefit from this. We were working on the most recent R release and yesterday we went to 15.5. When reindexing the entire database, 4D Server/4D are still going index by index instead of table by table.
Or maybe I missed something. Cheers, Paul > Le 21 avr. 2018 à 21:43, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > 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 > ********************************************************************** ********************************************************************** 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 **********************************************************************