the issue John brought up was the reindexing process. the cache appeared NOT to be used, and not to be set to large values.
>From John 2. Wait for hours and the progress bar finally reaches the last table and is pixels away from the end. Wait for many more hours, nothing seems to be happening even though 4D is using 100% CPU. Finally discover that 4D is indexing the database, but the indexing progress window is hidden behind the MSC window. 3. Wait many more hours, progress bar for creation of a single index on a table with 40 million records has barely moved. Cache used in creation of the index shows 0%. The database memory setting is 4GB. Activity Monitor shows 4D is using 300MB. I suspect when 4D restarts to open the database for compacting that it ignores the database memory settings. Indexing will never complete under these conditions. it seems to me that the issue here is the indexing process. hanse the idea to turn off indexes, and index separately. Chip On Thu, 26 Jul 2018 12:05:25 -0400, Jeffrey Kain via 4D_Tech wrote: > No longer needed in v16. A compact will reorganize the data file, > and then do a complete reindex. --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
