I'm opening and closing connections for every request -- I'm not sure
if i can keep a persistent connection with my setup. Each phone call
in FreeSWITCH runs in it's own thread, and Lua scripts are called at
various points during the phone call. This script runs, talks to the
database if necessary, passes information back to FreeSWITCH, then
finishes.
I'm open to finding a way to use persistent connections in my setup.
However, it also seems like LuaSQL should run smoothly even when many
connections are opening and closing. If we're running out of memory,
then there's a memory leak somewhere, right?
>> 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).
_______________________________________________
Kepler-Project mailing list
Kepler-Project@lists.luaforge.net
http://lists.luaforge.net/cgi-bin/mailman/listinfo/kepler-project
http://www.keplerproject.org/