Hey guys, I've got one problem i think i know why its happening
After i press create char it takes 20 seconds to do it
Is it maybe because of the logs? My machine is very powerfull so i doubt its because of the machine.
Printable View
Hey guys, I've got one problem i think i know why its happening
After i press create char it takes 20 seconds to do it
Is it maybe because of the logs? My machine is very powerfull so i doubt its because of the machine.
its happen also to me and i have a great pc also
thats not lag its because u are in same pc with the server i think
Nah, not really
I got 2 PC's and both of them are beasts
This one that the server is hosted on has 3.5 gigs of ram, E7500 dual core, and what so ever, 2.5 gigs for VMWARE and gig for WINDOWS
Im playing it using an totally diffrent PC, and even some of my other players experienced this.
I doubt its connection problem because its the max connection i can get untill i move to the dedi in august.
have checked the logs, if there is someone mistake?
or even problem in SQL Server?
the most likely (I say that I also ami do), is that the problem is in the runtime sql response (intervals ).... that's my opinion .:blush:
Provide some basic information please:
- SQL Server Version and patchlevel (SELECT @@version),
- Operating Systems in use,
- Network connection (speed, hop-count, etc.),
- Do you use DNS to connect to your SQL-Server?
- When exactly do these delays occur (eg. first time connect only)?
Do you use linked server?
A linked server will slow things down as emi says. I don't recommend using a linked server for this and a few other reasons.
http://forum.ragezone.com/f460/remov...server-576629/
Aside from that the problem is going to be in the database as when you create a char several things are done in a stored procedure to look up the char template, copy all of the values to a temp table and then dump the temp table into the char table (well that is a simplified version of what it does anyway). If the SQL server is under load it will slow this process down.
Alphakilo23's mention of using DNS to connect to the SQL server is also a good point as DNS resolution could be slow, though i would expect any other type of query to be slow as well. What it is using is what you entered when asked for the SQL server in cabal_config (check in /etc/odbc.ini). If it has an IP address and not a machine name then you aren't using DNS.
I think it's going to be the linked server as it does slow things down a little. You said you are using the latest SQL, is that 2008? I have not used 2008 that much myself yet but i have noticed that executing queries in management studio seems slightly slower than 2005. I don't know if it is the same when connecting directly to the DB engine yet though as i only use 2008 in test environments at work where speed isn't an issue i would really notice.
so remove the linked server in the guide up,and it should be done
Deleted