Amit wrote:
> 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.
Hey you just invented the Apache::DBI module ;-)
