> You know the old saying: “A watched pot never boils.” > Watching 4D reload the same table with 7 million records 8 times to generate > 8 indexes is kind of like that.
Later versions of 4D optimized the index rebuilding by caching the records and doing all of the indexes on table at a time. If there is enough cache (memory) the second through 8 index would be much much quicker in that it wouldn’t need to reload the records in the table. Log story short, since you can’t get an SSD, maybe increase the server memory and cache size for reindexing. Neil ********************************************************************** 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 **********************************************************************
