Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re: best data model for chat program

by JPaul (Hermit)
on May 21, 2002 at 20:02 UTC ( [id://168248]=note: print w/replies, xml ) Need Help??


in reply to best data model for chat program

Asides from the lack of given information, you should possibly evaluate your first sentence.
"... best performance for a perl-mysql chat"
I'm guessing that you intend to make this accessable from a webpage, since if this was client or telnet accessed, using a DB backend would just be silly.
In this case, I would suggest you forget about using MySQL, or any RDBMS for that matter, as a back-end to this - as performance wouldn't be particularly impressive at all... To be honest, it'd be a very strange way of going about it with this example.

merlyn has already written a good column about web chatters: December 2000
This would probably be a good way to go about this :)

JP,
-- Alexander Widdlemouse undid his bellybutton and his bum dropped off --

Replies are listed 'Best First'.
Re: Re: best data model for chat program
by dev2000 (Sexton) on May 21, 2002 at 21:27 UTC
    I've found hundreds of PHP-MySQL chat scripts, yet little or no (mod_)perl counterparts. I think a mod_perl-MySQL based chat would perform and scale well if the data model was set up right. "Writing Apache Modules with Perl and C" suggested using MySQL this way and gave me the idea!
      And a mod_perl solution not using a database will perform even better.

      Makeshifts last the longest.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://168248]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others chilling in the Monastery: (9)
As of 2024-03-28 09:24 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found