Hi
I've ventured into the possibility o creating my own chat room for my website rather than using available scripts.
Having looked at how chat rooms are currently implemented in PHP and MYSQL, i've seen a good use of HEAP TABLES.
I understand these tables occupy memory onthe server, and wsas wondering wether it is safe to use them? do most hosts allow heap tables to be used?
thanks
heap tables for chat scripts
Moderator: General Moderators
I would bet your hosting provider supports heap tables, most providers dont know enough to turn them off. I would def take evilcoder's advice and ask before doing this though. But, depending on the amount of traffic it may not even make a dent in their cpu usage. MySQL has some built in options to stop heap tables from going crazy, I would use them to make sure you don't use all the ram by mistake. Have fun in heap land.