View Single Post
Manu127
Veteran Member
Join Date: Jul 2010
Location: Argentina
Old 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.
Manu127 is offline
Send a message via MSN to Manu127 Send a message via Skype™ to Manu127