R
Rob Fitzpatrick
Guest
> [2017/07/19@03:49:18.139+0100] P-4460 T-4928 I : (11480) Temporary sort file at f:\sort\ used up 259868928K of disk space. > [2017/07/19@03:49:18.141+0100] P-4460 T-4928 I : (11483) A total of 259868928K of temporary sort disk space was used for area 6. > That's a lot of disk io. So adding more RAM will help that? Not that we'll be able to add 260GB more! I presume putting the sort files on as fast a disk as possible will help? > Full idxbuild took 14.5 hours! 
Having large tables (or very many smaller ones) together in a single area will increase the required RAM to prevent temp file disk I/O. Having a well-designed structure will reduce the required RAM. Are all of the application tables in the schema area?
Continue reading...
Having large tables (or very many smaller ones) together in a single area will increase the required RAM to prevent temp file disk I/O. Having a well-designed structure will reduce the required RAM. Are all of the application tables in the schema area?Continue reading...