04.08.2014, 21:38
Use threaded queries for a start. Also, since you have a large database, make sure that it is properly indexed. Use the explain command extensively. Avoid full table scans.
Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time
« Next Oldest | Next Newest »
Messages In This Thread
Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - by iAnonymous - 04.08.2014, 21:09
Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - by Crystallize - 04.08.2014, 21:32
Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - by ViniBorn - 04.08.2014, 21:35
Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - by Vince - 04.08.2014, 21:38
Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - by iAnonymous - 04.08.2014, 21:38
Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - by Crystallize - 04.08.2014, 21:42
Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - by iAnonymous - 04.08.2014, 21:45
Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - by Crystallize - 04.08.2014, 21:52
Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - by iAnonymous - 04.08.2014, 22:33
Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - by Crystallize - 04.08.2014, 23:00
Users browsing this thread: 4 Guest(s)