Are you opening and closing connections for every request, or using a
connection pool/persistent connections? I'm not using LuaSQL in
production but have done load testing at 1000's of queries per second
with no issue using persistent connections (catching and re-opening
connections closed by MySQL as idle).
On 27 Sep 2009, at 9:44 PM, Chad Phillips -- Apartment Lines wrote:
After somewhere between 1500-2000 queries to the database (this is
in a 20-30 minute period), the driver hits this error in the code:
/* Try to init the connection object. */
conn = mysql_init(NULL);
if (conn == NULL)
return luasql_faildirect(L, "error connecting: Out of memory.");
_______________________________________________
Kepler-Project mailing list
Kepler-Project@lists.luaforge.net
http://lists.luaforge.net/cgi-bin/mailman/listinfo/kepler-project
http://www.keplerproject.org/
