Persistent database connections are an important and widely used feature of PHP. In combination with PostgreSQL, powerful and fast applications can be built because almost all overhead caused by authentication can be avoided. However, persistent database connections can in many cases be dangerous due to hardware and software issues. When working with transactions, it is important to keep in mind that open transactions might stay in memory after a script has terminated. Therefore, errors that are difficult to find can occur. |