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/

Reply via email to