heap tables for chat scripts

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
mzfp2
Forum Contributor
Posts: 137
Joined: Mon Nov 11, 2002 9:44 am
Location: UK
Contact:

heap tables for chat scripts

Post 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
evilcoder
Forum Contributor
Posts: 345
Joined: Tue Dec 17, 2002 5:37 am
Location: Sydney, Australia

Post by evilcoder »

most hosts dont allow chatscripts because no matter how they are implemented the server comsumption is huge and degradates performance.
kcomer
Forum Contributor
Posts: 108
Joined: Tue Aug 27, 2002 8:50 am

Post 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.
Post Reply