Abstract: Methods and systems are disclosed that effectively manage sockets in client-to-server connections at the application level to enhance the availability of sockets by timely closing idle sockets. This reduces the role of the TCP-level management to a single listen thread on a listen socket. Connected sockets are placed into the application's socket pool that is managed by a configurable number of worker threads. The proposed methods and systems are intended to prevent a situation where many connections are opened, thereby using all the network memory on the machine.

Abstract: A database interface architecture is disclosed that operates in an asynchronous mode, provides for load balancing over time, and is optimized for high speed. Even when the system is under light load, data is inserted into the database in a timely manner by flushing the buffer after a configurable time interval, regardless of how full or empty the buffer is, thereby ensuring that data does not remain in the buffer during times of light or no load. The buffer can also be flushed by setting a flag whereby the buffer is flushed regardless of the timestamp on the buffer.