From 87cbafce2d6803af78714baf8bba64309c01fc33 Mon Sep 17 00:00:00 2001
From: Derek Jones
Date: Fri, 27 Feb 2009 16:29:59 +0000
Subject: added reconnect() method to db drivers
---
user_guide/changelog.html | 1 +
user_guide/database/connecting.html | 5 +++++
2 files changed, 6 insertions(+)
(limited to 'user_guide')
diff --git a/user_guide/changelog.html b/user_guide/changelog.html
index cdbfbbd04..3ddaf8d08 100644
--- a/user_guide/changelog.html
+++ b/user_guide/changelog.html
@@ -74,6 +74,7 @@ SVN Revision:
Updated all database drivers to handle arrays in escape_str()
Added escape_like_str() method for escaping strings to be used in LIKE conditions
Updated Active Record to utilize the new LIKE escaping mechanism.
+ Added reconnect() method to DB drivers to try to keep alive / reestablish a connection after a long idle.
diff --git a/user_guide/database/connecting.html b/user_guide/database/connecting.html
index 3579e1af6..b4d517941 100644
--- a/user_guide/database/connecting.html
+++ b/user_guide/database/connecting.html
@@ -158,6 +158,11 @@ you can pass the connection values as indicated above).
+Reconnecting / Keeping the Connection Alive
+
+If the database server's idle timeout is exceeded while you're doing some heavy PHP lifting (processing an image, for instance), you should consider pinging the server by using the reconnect() method before sending further queries, which can gracefully keep the connection alive or re-establish it.
+
+$this->db->reconnect();
--
cgit v1.2.3-24-g4f1b