[iJumbo]

only a question.. if every time player send a text i store it in mysql i can cause awesome lag?

[Calgon]

It depends on how much text is being stored.

I do this in a script I created and it's pretty much fine, but I haven't had large amounts of players to test it with, although there's 23,947 chatlog entries.

[Joe Staff]

I wouldn't suggest doing it every time a player speaks but rather every 10th or 20th time a person speaks and/or every minute

[Vince]

MySQL is designed to handle large amount of data, and insert queries like the chat shouldn't cause much trouble. It takes less than a millisecond to execute the query. Fetching a single page on this forum already takes an average of 12 queries.