I'm making a MUD, and the DB will contain all of the information about players, rooms, mobs, text, helps, objects....during fighting hp can change by the second for multiple users.

I see. I still think you're starting your optimization at the wrong end. First make sure that your database design is efficient - it's the updates to the database that are likely to take most time and are likely to most affect the speed of the app (or at least that's been my experience...)

Michael