|
Veteran Member
Join Date: Jul 2010
Location: Argentina
|
01-17-2012
, 19:54
Re: Sistema de cuentas MYSQL/SQLITE con/sin encriptación
|
#10
|
Tendrias que arreglar lo del sql injection.
Un amigo, nisiquiera le aparece el menu, pasa de 1 al game sin registrarse/loguearse.
Las thread query no interrumpen el juego, es una nueva manera de consulta que, cuando la ejecutas, espera la respuesta en otro sub-proceso, sin interrumpir el juego.
En cambio, las prepare query van a tildar el juego segun su tiempo de respuesta, lo comprobe yo mismo.
Tenia 1 segundo de delay, con thread query no pasaba nada. En cambio, con prepare query se te tilda 1 sec el servidor. Eso es porque las thread se ejecutan en un subproceso, y no afectan el game play.
Aca taba buscando un post y lo encontre, mira:
Hawk552:
The true power lies in threaded querying. Threaded querying means nothing short of a rewrite of an entire plugin that's written with DBI, but has huge advantages, especially on slow connections. The idea of a threaded query is essentially that a new thread (a sub-process) with which its only goal is to send, monitor, and inform of the things that happen to a query. Because it is on a seperate thread, a query that would normally take 1 second (and 1 second of total connection loss for all clients in the server) still takes the same amount of time, but does not interrupt gameplay.
__________________
Last edited by Manu127; 01-17-2012 at 19:55.
|
|
|
|