Ulysses Stuff > Ulysses Release Archives

Uban PHP Viewer

<< < (6/11) > >>

JamminR:
Is there not a way to make the gm_sql library run threaded? That is
Fake code-
Stored banlist -
Connect to SQL database
write stored banlist
<gmod, other lua scripts keep running here, not waiting on above lines>
<close connection>

Megiddo:

--- Quote from: JamminR on June 07, 2008, 05:10:53 AM ---Is there not a way to make the gm_sql library run threaded? That is
Fake code-
Stored banlist -
Connect to SQL database
write stored banlist
<gmod, other lua scripts keep running here, not waiting on above lines>
<close connection>

--- End quote ---

gm_sql runs asynchronously ("threaded") all the time.

MrPresident:
I wish that were true Meg. With gm_sql whenever it attempts to make a connection, if it can not, the whole game server stops responding and everyone on it times out for about 10-15 seconds. then everything resumes. Of course, this only happens when it CANT connect.


OH WAIT.. I wonder.. Now that I think about it, It didn't lag when I was playing a listen server doing some tests.. I would just get the errors, but no lag. (threaded?) Maybe my dedicated server doesn't allow threaded processes since we are sharing a box with other clients? Is this possibly the case?

JamminR:

--- Quote from: MrPresident on June 07, 2008, 11:46:37 AM ---doesn't allow threaded processes since we are sharing a box with other clients? Is this possibly the case?

--- End quote ---

Uh, won't say no, but, 99% doubtful.
I didn't mean threaded as in multi-core type threading anyway.
Just meant as in programming 'fork' where each process takes turns (as equally as possible).
Sounds like ded server gm_sql or lua calls to it aren't sharing as nice as they should.

spbogie:
The calls to the gm_mysql module are all blocking because they all return a value depending on the result of the connection, however, they should all gracefully timeout after a short period of time if they can't connect.

Navigation

[0] Message Index

[#] Next page

[*] Previous page

Go to full version