ok im still very rusty with all this php/sql/ajax business so please concider me a n00b .. last time I did web design frames were all the rage.. :/ yea
anyway so Ive setup a PFC on my website but last night when I had only 15 users on chat my hosting which I thought was unlimited temporarily shut the site down due to to many SQL database queries as their maximum ive now learned is 50,000 per hour , also upon checking the stats my site had over 340,000 "hits" out of a limit of 500,000 , now 90% of both the hits were created in 1 day from the new 15 users and it killed chat in around 30 minutes.
so id rather post here and be told its something simple and ive been stupid that to slave over it trying to save face , so heres my questions:
looking at purely the SQL , is there a way to reduce the ammount of queries thrown at the SQL database? and how many queries should it be generating with 15 users?
Im still un-sure as to what "site hits" actually are .. are they simply a per click thing? or per every html interaction? so really what im asking is could it be chat that is creating these large numbers or the forums?
PFC is currently linked into the PHPBB3 boards usernames so we can have auto-mods and names etc could this account for the high SQL and site hits?
The ping function on PFC updates quite regularly could that add to things?
and finally .. just a general help.. the chat was put up to handle up to 50 users which I know is alot but if I cant even have 15 without killing the site then ill have to move to a new chat system.. probably and quite depressingly a java one, so any ideas are more than welcome.
thanks in advance for any replys and im sorry if there was something similar on this but I couldnt find it.
thanks.