[Release] Simple MySql Pool handler

[marlyandedsel]

thanks fang .... it is very useful I will do it in your way.....

#region Kill Sleeping Connection
private void Loop()
{
int count = 0;
while (1 > 0)
{
Sleep(2000);
count++;
if (count > 29)
{
Conquer_Online_Server.Database.KillConnections.Kil l();
count = 0;
}
Sleep(Milliseconds);
}
}
#endregion

Fang I have come up with that code, is that correct? and put it in the thread system

[Spirited]

try something like this...

while (true)
{
     Database.KillConnections.Kill();
     Thread.Sleep(30000); // Sleep for 30 seconds 
}

Make sure that it's on its own thread though. Do NOT put it on the main thread or it'll lag your server.

[marlyandedsel]

thanks fang..... thanks very much

[alanpk2009]

Fang please give you yahoo or mensseger my is

[Spirited]

Originally Posted by alanpk2009

Fang please give you yahoo or mensseger my is

It's not public for a reason.
I'm not going to guide you on how to do this for your source. You need to think it through and implement it using the C# you know.

[marlyandedsel]

Fang I did something like this

1.I have put public static for ServerManagement as a new thread that run every 30 sec
I put in the program class

2.I called the ServerManagement as a New Action and I called it like ServerManagement.start();

3. I create a static void for ServerManagement_Execute()
inside it i call the Database.KillConnection.Kill();

its very useful, it slow the memory usage of the server every time the server call that, and its working fine... thanks fang.......

[alanpk2009]

please need help

[marlyandedsel]

like fang he said, you have to think of it and learn how to do it okay ? thats what I do lol......

[alanpk2009]

just want to ask you a question

[zzaki201065]

where can i add them plz Help me