MYsql Data Exception.

08/26/2011 18:17 kioklo#1

Hello, i got little bug in my server that do that and We can't log in, Major lag in game :S

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

I pray my screen will help to understand.

08/26/2011 18:23 Spirited#2

Sleeping connections are maxing out the connection pool.
[Only registered and activated users can see links. Click Here To Register...]
Add a new thread that runs that every 30 seconds and remember to DISPOSE of your connections..

08/26/2011 18:28 kioklo#3

Thanks fang, u are very helpfull for me

ok you will probaly think i'm stupid but ...Where to put it lol

I'm looking for answer again :P Thanks for watching

08/27/2011 22:44 MidNewt#4

Thanks for the code where i put it?

08/28/2011 00:51 Spirited#5

Quote:

Originally Posted by MidNewt

Thanks for the code where i put it?

Nobody on earth will tell you. I already told you want to do.
I don't help people who can't help themselves.

08/28/2011 01:57 MidNewt#6

If i understand good i need to add new Thread so probaly in Thread.cs? and if i need to run that every 30 seconds probaly in programs.cs.

08/30/2011 12:00 kioklo#7

Thanks for the code...my source crash and i can't fix it lol..

08/30/2011 17:27 Spirited#8

Quote:

Originally Posted by kioklo

Thanks for the code...my source crash and i can't fix it lol..

:facepalm:
My code doesn't cause anything to crash.
You must be using it VERY VERY wrong then.