Chat Sessions - Memory engine a good fit?
I have an online chat service that stores chat sessions in an InnoDB table. Each user in a chat room makes a request to the server every few seconds. The script requested needs to query the user sessions table with a SELECT statement for all the users currently in the room. But, it also needs to UPDATE the user sessions table to store information like a timestamp of the last request and the key of the last served message.
It seems like the Memory engine would be a good fit considering this data is small and expendable when there's a crash... But, I'm not sure about the high volume of UPDATE queries. Would this be okay with Memory engine's table locking or should I stay with InnoDB and its row locking?
Subject
Views
Written By
Posted
Chat Sessions - Memory engine a good fit?
6354
August 06, 2010 06:07PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.