We highly recommend that you read and follow the recommended practices in the TimesTen Best Practices Guide. Specifically, you should follow the recommendations in the following areas:

Programming Usage Considerations - Milliseconds count - use direct-linked connections for best response time - Prepare queries and bind columns and parameters in advance - Tune your application connections and use connection pooling - Close cursors promptly - Commit transactions regularly

Schema Considerations - Create appropriate indexes - Update statistics - Review Query Plan and act accordingly

		Hardware Considerations - Separate transaction logs and checkpoint files on separate disk drives - Disk speed matters - use faster disks for write intensive applications - Faster processor improves transaction response time and throughput - Ensure high network bandwidth and low network latency for consistent replication performance

OS Considerations - Use memory locking and large pages - Configure large OS TCP buffer windows - Configure sufficient number of OS semaphores