I'm a noob developer. Trying to develop a simple php-mysql based chat script.
I'm stroing all of my chat message's in a table. So to retrive em, im running a mysql query. Here is no problem but im concerned that it may create some performance & speed issues when a user will keep chatting all day long, i mean in case of looong chat thread, mysql query will take a little time and that will be disgusting!
So folks whats your suggestion for me? [Please don't say like just "use ajax"/"go with text file"...please write little details too since im a noob hehe]