User Manager causes 97% CPU

[Jerre]

Hi TeamSpeak,
Just imported a DB of a Linux TS server into a new Windows server (replaced the files)
Everything works nicely, but when I got to the user manager in the webadmin, the page is not displaying, and the CPU load is 97% :s this causes the server to crash.

Strange thing is, that I've tested it before on this server, and it worked, but suddenly it didn't work anymore?

please help asap thnx

[Jerre]

Ok looks like the problems are caused due to a gigantic database.
I deleted all users that have never logged in and now the high cpu load is only for 2 mins, while loading the page. It's still not quite fixed dough :s

Has anyone experience with making the db more faster?
Is importing the database into mysql a good option?

[karimali831]

I've switched from linux to windows webhosting and here my results:

==============================================
Resource Capacity
CPU The resource is in Green Zone


1.0%

System Usage
Resource Capacity
System The resource is in Green Zone



53.75%
=============================================

53% % of the whole system and 0% of CPU although running 3 Teamspeak Servers, and when running 5 Vent the system Resource is just 20 30 %

[Jerre]

And when you go to the user manager?