Parallel Query Execution Mechanisms (cont.)
Tuning
- Major problems
- Control overhead
- Interference
- Synchronization delays
Architecture
- Discussion of which architecture is best
- Chose hierarchial
Notes:
Ctrl overhead: have the number of ctrl pages linear to number of processes & use primed processes with primed connections (pg. 103)
Sync: try but not force process-process infinity
Chose hierarchial because it combined the better qualities of the other architectures.