Data must be accessed quickly, and the warehouse should be capable of handling it as needed without using excessive CPU cycles or running out of memory. With data connectivity solutions from DataDirect, you will be able to minimize the CPU and memory footprint of your data warehouse and support more simultaneous users and database connections with the same or less hardware Here are just some of the performance-tuning features we offer to make that possible:
- Connection Pooling
- Thread Pooling
- Statement Pooling
- Network packet management
- Caching, and data buffering optimization for reducing network roundtrips
- TCP/IP socket management for greater CPU efficiency
- Promotion of parameter array, batch insert operations to bulk load for fastest available performance for mass insert operations
- Bulk load functionality can be leveraged for the best possible database and application performance for inserts of very large result sets with your data warehouse