NationStates Jolt Archive

i get an error message often when i try to get here.

Largely because it was designed to support a couple thousand accounts, as opposed to a hundred-thousand.

However, once the migration is over, all those problems should largely vanish.

migration?? also what they shopuld do is prune inactive and duplicate members

We do prune inactive members. After 28 days (60 on vacation mode).

MySQL is designed to run thousnads of coonections per second.

Please ensure that all of your script kill the database connection when they complete, failure to do this will result in well royally b0rk3d tables.

If MySQL could handle it and phpBB couldn't then http://www.go-gaia.com would never have got running.

PHP automatically closes the connection at the end of a script. However, the performance hit from closing all connections the moment you're done with them only to open them a moment later would be...gigantic. *wonders if permanent connections are being used instead of the ordinary ones* I think this is more because of [violet]'s modifications to the phpBB script. Although I could be wrong.

PHP automatically closes the connection at the end of a script. However, the performance hit from closing all connections the moment you're done with them only to open them a moment later would be...gigantic. *wonders if permanent connections are being used instead of the ordinary ones* I think this is more because of [violet]'s modifications to the phpBB script. Although I could be wrong.

I beg to differ.

If php(BB) closed the connection automatically there would be no need for this line from includes/page_tail.php

[code:1:d6612b17dc]$db->sql_close();[/code:1:d6612b17dc]

You see if you fail to close a connection the databae becomes bloated with connections and leads to a too many connections error, and in some cases a server crash.

Perhaps, if nations didn't post numerous same-type threads all the time that turn into pointless spam... well, it wouldn't be as bad.

Perhaps, if nations didn't post numerous same-type threads all the time that turn into pointless spam... well, it wouldn't be as bad.

This is true, but as I said before MySQL can handle it as can phpBB.

Hence the existance of http://go-gaia.com which as you can see is just pure spam.