best type of table for arrowchat messages in MySql

[BBurgos Martinez]

I'm wondering what would be the best type of table for the arrowchat where all the messages are stored. I was thinking since it's a lot of inserts, then innodb would be optional. I was also thinking of switching it to a MEMORY table since message history isn't important to me. My question would be, what table type would performance the best(to reduce server load), MyISAM, Innodb, or MEMORY?

Note, that I have no need for keeping records of messages. Also, I run a cron job once a week to keep my table under 100k rows.

Thanks.

[BKim]

Hey there,

I changed arrowchat, arrowchat_chatroom_messages, arrowchat_chatroom_users, and arrowchat_status to MEMORY and haven't had any adverse issues. You'll have to change all the TEXT/BLOB tables to varchar before you do this though.

To be honest I'm not sure if there are any performance improvements, although to my knowledge this should prevent arrowchat from reading from the disk for chat and chatroom messages.

[BBurgos Martinez]

that's for the reply :)

Will give it a try.

[Staff Bot]

[b]This thread has been locked because the last post is greater than six months old. There is a good chance that the information in this thread is outdated. Please open a new topic if you wish to discuss this further.[/b]