Temporary or constant MySQL connection? - 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: Temporary or constant MySQL connection? (
/showthread.php?tid=132357)
Temporary or constant MySQL connection? -
Ellis - 07.03.2010
In which cases temporary or constant MySQL connection is better? What do you preffer?
Re: Temporary or constant MySQL connection? -
Carlton - 07.03.2010
It depends what you're doing. In my opinion, I think a constant MySQL connnection is better, because it's less work to keep closing the connection in re-connecting. To be honest, I don't know what you mean by temporary? Do you mean in a case where you load data from a db and close the connection?
Re: Temporary or constant MySQL connection? -
Ellis - 07.03.2010
Quote:
Originally Posted by Carlton
I don't know what you mean by temporary? Do you mean in a case where you load data from a db and close the connection?
|
Yes.
Waiting for more opinions.
Re: Temporary or constant MySQL connection? -
Carlton - 07.03.2010
Quote:
Originally Posted by Ellis
Quote:
Originally Posted by Carlton
I don't know what you mean by temporary? Do you mean in a case where you load data from a db and close the connection?
|
Yes.
Waiting for more opinions.
|
You can do that not a big problem, I just use constant for loading data, and saving it at the end when a player disconnects. So say like, you're using a temporary connection ok, and you wan't save data when a player leaves or something, the DB will keep connection and re-connecting over and over again, it's better to just leave it connected until you exit the GM or the Filterscript.
Re: Temporary or constant MySQL connection? -
Ellis - 07.03.2010
Sure, i do understand that keeping MySQL connection constatly speeds things up because connecting takes a little time (not sure how much). But what about memory? Still looking forward to other's opinion.
Re: Temporary or constant MySQL connection? -
Carlton - 07.03.2010
Quote:
Originally Posted by Ellis
Sure, i do understand that keeping MySQL connection constatly speeds things up because connecting takes a little time (not sure how much). But what about memory? Still looking forward to other's opinion.
|
No it doesn't, well, depends what plugin you're using, [RAZ]ADreNaLiNe-DJ's mysql plugin is a bit slow connecting, the others work fine. I don't know about memory though, all I know is it's not much.
Re: Temporary or constant MySQL connection? -
Ellis - 07.03.2010
Does everyone think the same?