I am not looking for someone to give me code nor am I doing this for homework a friend of mine is wanting me to build a site for them that includes an instant messenger like what they have on facebook. Initially I thought of Ajax to constently check to see if there is a new message in the database or not. So if you were IM'ng me you would send an IM which would write to a table and my page would do a constent check to see if there was a new message for me.
I ran this idea off to one of my friend which is a good database developer and according to him this could potentially cause an indexing issue on the database and potentially cause the db to crash if the site got alot of hits... So now I am back at square one with this. Does anyone else know of a different more efficient way of doing this?
