On Thu, 19 Apr 2001, 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.
Use mod_perl and Apache::DBI.
-- Brett
http://www.chapelperilous.net/btfwk/
------------------------------------------------------------------------
Q: What's the difference between USL and the Titanic?
A: The Titanic had a band.
