You see I have designed a chat interface in perl which connects to mysql to
store chat transacripts and to show the chat sessions. Eg. Say I am
chatting, I type a message it stores it into mysql. Now, the place where the
chat appears, the page is refreshed every 5 seconds to get the transcripts
from the database. Now, at the moment everytime it has to connect to the
database to get info. to write or read...this causes a burden on the server.
Is it possible somehow that I keep the connection open and keep reading and
writing to mysql which would not strain the server as I assume when multiple
people will be chatting the server will get overloaded and crash.
Amit
