[Ellis]

In which cases temporary or constant MySQL connection is better? What do you preffer?

[Carlton]

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?

[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.

[Carlton]

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.

[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.

[Carlton]

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.

[Ellis]

Does everyone think the same?