Mysql Forum/Server Chat - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Mysql Forum/Server Chat (/showthread.php?tid=253677)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Mysql Forum/Server Chat (/showthread.php?tid=253677)
Mysql Forum/Server Chat - iJumbo - 07.05.2011
only a question.. if every time player send a text i store it in mysql i can cause awesome lag?
Re: Mysql Forum/Server Chat - Calgon - 07.05.2011
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.
Re: Mysql Forum/Server Chat - Joe Staff - 07.05.2011
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
Re: Mysql Forum/Server Chat - Vince - 07.05.2011
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.