Page 1 of 1

heap tables for chat scripts

Posted: Thu Dec 26, 2002 7:36 am
by mzfp2
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

Posted: Thu Dec 26, 2002 4:12 pm
by evilcoder
most hosts dont allow chatscripts because no matter how they are implemented the server comsumption is huge and degradates performance.

Posted: Thu Dec 26, 2002 4:29 pm
by kcomer
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.