1. Understanding Installation Considerations : Use of Ingres Locations : Location Use During OLTP Operations
 
Share this page                  
Location Use During OLTP Operations
If your system processes small transactions and no queries handle large amounts of data--as in an Online Transaction Processing system--then the use of all locations is more uniform and predictable. There will be many random small reads instead of scanning of data files. The Work location will be used less because small sorts occur in memory.