Board Index | Search | Profile |
Page 1 of 5 |
[ 75 posts ] | Go to page 1, 2, 3, 4, 5 Next |
Print view | Previous topic | Next topic |
Author | Message |
---|---|
Site Admin / Dev Team
Team:
Rank: Director Main: Jeff_L Level: 1969 Joined: Wed Mar 23, 2005 2:21 am Posts: 3894 Location: Santa Clara, CA |
While my new networking code seems to have the main loop of the server running faster on average, I am still seeing some lag spikes. I added a bunch of timers in the last patch and have isolated with some good certainty what most of these lag spikes are. They are read queries to the DB when someone is logging in. It doesn't happen every time someone logs in, but often enough.
I don't see anything particularly bad or slow with these queries, but what I am going to try is multithreading the log in process so that no matter how slow it is to read in the initial data from the db, it won't slow or lag the main loop. Right now in code, there are only a couple times we actually read from the DB. Mostly we write and all those writes are currently passed off onto another thread, so doing the same with reads makes sense. _________________ For support, please create a support ticket here and I will get back to you as soon as possible. About Star Sonata. Last edited by JeffL on Wed Jan 23, 2008 5:40 am, edited 1 time in total. |
Mon Jan 14, 2008 3:37 am |
|
Joined: Mon Jun 11, 2007 4:39 pm Posts: 30 |
Sounds good, as long as it works
_________________ |
Mon Jan 14, 2008 4:58 am |
|
Main: Goz
Level: 1564 Joined: Sat Dec 17, 2005 9:39 pm Posts: 83 Location: Eredar US, Gozmatic (Horde) |
yayy less lag is good, go jeff!
_________________ 2nd place is just another way to say 1st loser. |
Mon Jan 14, 2008 7:11 am |
|
Team:
Rank: Councilor Main: Qu4NtuM Level: 7790 Joined: Tue Dec 20, 2005 5:16 pm Posts: 326 Location: At work... |
Noticed that the huge spikes occur every 1hour. Could it be cause by the DB backup or maybe some other job?
_________________ Julian wrote: In ss we fill breast implants with sand because we are to cheap to purchase silicone. Battlecruiser23 wrote: I have reasons for why I do things. |
Mon Jan 14, 2008 8:46 am |
|
Team:
Rank: Main: Nurokourri Level: 5049 Joined: Sat Aug 21, 2004 6:48 pm Posts: 1056 |
Sounds good. Nice to hear an update on it.
_________________ Fucking loot... |
Mon Jan 14, 2008 8:46 am |
|
Team:
Rank: Operator Main: Teh Haxzorz Level: 2443 Joined: Thu Apr 27, 2006 1:58 am Posts: 501 Location: United Kingdom |
Good to know that you are hard at work at solving some of the lag issues Jeff. Thanks for the info.
Last edited by Grunt on Mon Jan 14, 2008 11:14 am, edited 1 time in total. |
Mon Jan 14, 2008 10:42 am |
|
Member
Team:
Rank: Director Main: ERMAN Level: 8516 Joined: Fri Jun 24, 2005 1:27 am Posts: 840 Location: SW Michigan, USA |
Like i said in other posts, it REALLY GREAT to have some info on what the hell is going on...even if I don't quite know exactly what you are meaning, its nice to see that problems are being identified and solved.
Also, giving us info like that can allow some of the more experienced people with coding/servers the ability to help or suggest solutions that perhaps the admins dont think of.. Remember that we want this game to work really well too. -ERMAN _________________ "I reject your reality, and substitute my own." "If I were an enzyme, I'd be DNA Helicase so I could unzip your genes." |
Mon Jan 14, 2008 10:55 am |
|
Member
Team:
Rank: Main: Wasup999998 Level: 1921 Joined: Sat Apr 09, 2005 2:03 pm Posts: 152 |
/me smacks the DB what did I tell you about being slow, can you not read good or something! Thwack! Read faster!
Good idea Jeff, I like to know stuff like that cause I actually understand it ^.^ _________________ "Thanx wasup " ~The Voomy One Ha! |
Mon Jan 14, 2008 3:36 pm |
|
Team:
Rank: Main: Green Dragon Level: 2546 Joined: Sun Jul 18, 2004 5:08 pm Posts: 584 |
Hey jeff, that is the case, but you only made the lag worse imo, it's not just me, the lag spikes are just longer and more often. For some reason, my SS runs better if a have a different program running in the foreground, and SS is in the bg, and when i have a really bad lag spike, i minimize SS, and that sometimes works. A little puzzling to me
~GD _________________ College Sucks *̡͌l̡*̡̡ ̴̡ı̴̴̡ ̡̡͡|̲̲̲͡͡͡ ̲▫̲͡ ̲̲̲͡͡π̲̲͡͡ ̲̲͡▫̲̲͡͡ ̲|̡̡̡ ̡ ̴̡ı̴̡̡ *̡͌l̡*. |
Mon Jan 14, 2008 3:58 pm |
|
Main: Goz
Level: 1564 Joined: Sat Dec 17, 2005 9:39 pm Posts: 83 Location: Eredar US, Gozmatic (Horde) |
ijij wrote: Hey jeff, that is the case, but you only made the lag worse imo, it's not just me, the lag spikes are just longer and more often. For some reason, my SS runs better if a have a different program running in the foreground, and SS is in the bg, and when i have a really bad lag spike, i minimize SS, and that sometimes works. A little puzzling to me ~GD if you can do things to maniulate your client to stop lag then its you, not the server _________________ 2nd place is just another way to say 1st loser. |
Mon Jan 14, 2008 4:32 pm |
|
Team:
Rank: Main: Nurokourri Level: 5049 Joined: Sat Aug 21, 2004 6:48 pm Posts: 1056 |
BAM5992 wrote: if you can do things to maniulate your client to stop lag then its you, not the server Before people bash Goz, he did just get something correct. Goz got 120 xp. Goz leveled up! _________________ Fucking loot... Last edited by Nuromishi on Mon Jan 14, 2008 11:20 pm, edited 1 time in total. |
Mon Jan 14, 2008 4:58 pm |
|
Team:
Rank: Director Main: goldstar-stations Level: 6537 Joined: Sun Nov 13, 2005 12:54 pm Posts: 1174 |
yea i gota agree. goz gave some decently informed advice!
if anything you do on your computer effects the speed and/or quality of the connection it is your computer not SS. maybe your video card or perhaps the computer just isnt strong enough to push through the application with other processes running in the backround. might want to try some heavy virus scanning. they effect computers big time. _________________ |
Mon Jan 14, 2008 10:06 pm |
|
Team:
Rank: Officer Main: .,+*"I.+**oVo**+.I"*+,. Level: 2793 Joined: Fri Sep 29, 2006 7:27 am Posts: 115 Location: Sitting infront of Computer |
GOZ! - I am shocked , some marked improvement from you in the last few months, prehaps you are aging!
-oVo |
Tue Jan 15, 2008 7:02 am |
|
Team:
Rank: Main: Urqa Ki Aka Kusa Level: 5113 Joined: Sun Nov 26, 2006 1:38 am Posts: 6 |
Goz may be correct, but if thats the case then the System Requirements are fucked up.
I have a 64 MB Video Card, thats 4x what this game needs. And i still get insane Graphics Problems, i get a low FPS, and thats all. |
Tue Jan 15, 2008 7:38 am |
|
Team:
Rank: Main: Nurokourri Level: 5049 Joined: Sat Aug 21, 2004 6:48 pm Posts: 1056 |
Original Soulless wrote: Goz may be correct, but if thats the case then the System Requirements are fucked up. I have a 64 MB Video Card, thats 4x what this game needs. And i still get insane Graphics Problems, i get a low FPS, and thats all. With a 16MB video card I can get around 22-28 FPS. I would suggest: lowering your resolution, running fewer programs, scanning for spyware/adware/viruses (I personally prefer Spybot Search and Destroy as well as AVG Free). If you are running Vista that can also be an issue: I personally prefer Windows NT5.0 (Windows 2000) for only running Star Sonata, as it works properly without the increase in system usage by unnecessary software present in Vista and XP. You could also try disabling the Aero or Luna GUI of Vista/XP and using Classic. As well, you have to consider what the game lists are minimum requirements: minimum won't get you very far. _________________ Fucking loot... |
Tue Jan 15, 2008 8:52 am |
|
Page 1 of 5 |
[ 75 posts ] | Go to page 1, 2, 3, 4, 5 Next |
All times are UTC - 5 hours |
Who is online |
Users browsing this forum: No registered users and 15 guests |
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum |