Is it efficient to store things in MEDIUMTEXT columns?
I am developing a web based system (using perl and MySQL) for viewing an
archive of mailing list messages. In my database, I have one row per
message. The column called "message" is of type MEDIUMTEXT. My perl code
retrieves it using $sth->fetchrow_hashref and then prints it. Message size
is typically ~10K; sometimes it's as high as a few hundred K.
Here's an example URL from my site:
http://qd.anifics.com/browse.asp?y=1995&m=12&d=30
I'm wondering if it's a good idea to use MEDIUMTEXT like this, or should I
put the message body into individual separate files? It runs fine right
now, but I'm worried that it won't scale up under significant load.
-Philip Mak ([EMAIL PROTECTED])
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
