UTF8 and Speedups

Archival storage for Announcements. Peruse old Announcements here!

Moderators: Community Team, Global Moderators, Media Team

Forum rules
Please read the Community Guidelines before posting.

UTF8 and Speedups

Postby lackattack on Thu Oct 29, 2009 6:51 am

UTF-8

I've converted the website and database over to the UTF-8 character encoding. This means that we can now have game chat in all languages from japanese to hebrew! It is a first step towards translating Conquer Club in different languages, and other website improvements.

Speedups

I also defragmented the database and fixed a few bottlenecks...

  • The view entire log link is now 5x faster, which is nice because some longer games took a while to load.
  • Each hour, when the website cleans up expired game invites, several games would lock up for about 3 minutes or more. This has been eliminated.
  • Game finder searches for specific maps are now much faster.

I'll now start working on these issues:
  • Each night several games lock up due to an email issue
  • The game interface needs to be more fault tolerant so that it doesn't freeze when the server has a "hiccup".
User avatar
Private 1st Class lackattack
Retired Administrator
 
Posts: 6235
Joined: Sun Jan 01, 2006 10:34 pm
Location: Montreal, QC
Medals: 9
Standard Achievement (1) Doubles Achievement (1) Triples Achievement (1) Freestyle Achievement (1) Speed Achievement (1)
Teammate Achievement (1) Cross-Map Achievement (1) General Achievement (2)

Re: UTF8 and Speedups

Postby colton24 on Thu Oct 29, 2009 6:55 am

=D> =D> =D> =D> Nice updates!
Highest Rank: Lt | Highest Score: 1641
Mr. Squirrel wrote:
pmchugh wrote:BUMP- one more fool needed :mrgreen:

One fool reporting for duty!
User avatar
Private 1st Class colton24
 
Posts: 1923
Joined: Mon Jun 22, 2009 8:27 am
Location: Alabama
Medals: 22
Standard Achievement (2) Doubles Achievement (1) Triples Achievement (1) Terminator Achievement (1) Assassin Achievement (1)
Manual Troops Achievement (1) Freestyle Achievement (1) Fog of War Achievement (2) Speed Achievement (2) Teammate Achievement (1)
Cross-Map Achievement (1) Ratings Achievement (2) General Achievement (2) Training Achievement (1) Tournament Contribution (3)

Re: UTF8 and Speedups

Postby Dako on Thu Oct 29, 2009 6:58 am

Great thing about UTF-8. It works! Cyrillic characters in the chat! Woohoo! =D>
Image
User avatar
Brigadier Dako
 
Posts: 3942
Joined: Sun Aug 26, 2007 9:07 am
Location: St. Petersburg, Russia
Medals: 115
Standard Achievement (3) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (1) Manual Troops Achievement (2) Freestyle Achievement (2) Polymorphic Achievement (1) Nuclear Spoils Achievement (2)
Fog of War Achievement (3) Trench Warfare Achievement (1) Speed Achievement (1) Teammate Achievement (2) Random Map Achievement (2)
Cross-Map Achievement (3) Battle Royale Achievement (1) Ratings Achievement (3) Tournament Achievement (13) General Achievement (24)
Clan Achievement (20) General Contribution (20)

Re: UTF8 and Speedups

Postby Duality. on Thu Oct 29, 2009 6:58 am

Thanks! :)
User avatar
Sergeant 1st Class Duality.
 
Posts: 331
Joined: Sat Oct 10, 2009 4:38 pm
Medals: 26
Standard Achievement (3) Doubles Achievement (2) Triples Achievement (1) Quadruples Achievement (1) Assassin Achievement (2)
Manual Troops Achievement (2) Freestyle Achievement (3) Fog of War Achievement (3) Speed Achievement (3) Cross-Map Achievement (3)
Ratings Achievement (3)

Re: UTF8 and Speedups

Postby asuman1179 on Thu Oct 29, 2009 8:45 am

That is great.
Private asuman1179
 
Posts: 31
Joined: Tue Sep 08, 2009 8:18 pm
Location: Denver, CO
Medals: 16
Standard Achievement (2) Doubles Achievement (2) Triples Achievement (1) Quadruples Achievement (1) Terminator Achievement (1)
Manual Troops Achievement (1) Freestyle Achievement (1) Nuclear Spoils Achievement (1) Fog of War Achievement (2) Teammate Achievement (1)
Cross-Map Achievement (1) Ratings Achievement (2)

Re: UTF8 and Speedups

Postby psychobkrazy on Thu Oct 29, 2009 9:47 am

Thank you! :D =D>
Image
PM me with "Tournament Invite List" in the Subject to get on my Invite List.
Highest Rank: 3070 Image Brigadier - #70 (page 1) - 61% Won - 01/02/2011
The Sigatar Lounge
User avatar
Major psychobkrazy
 
Posts: 815
Joined: Wed Jul 30, 2008 8:03 am
Location: near Detroit
Medals: 109
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (4) Terminator Achievement (2)
Assassin Achievement (2) Manual Troops Achievement (4) Freestyle Achievement (3) Nuclear Spoils Achievement (3) Fog of War Achievement (4)
Trench Warfare Achievement (3) Speed Achievement (3) Teammate Achievement (3) Random Map Achievement (2) Cross-Map Achievement (4)
Beta Map Achievement (1) Ratings Achievement (4) Tournament Achievement (6) General Achievement (5) Clan Achievement (14)
Tournament Contribution (31) General Contribution (1)

Re: UTF8 and Speedups

Postby laddida on Thu Oct 29, 2009 10:06 am

still getting alot of slow response time, sometimes it will respond right away or something it will take 30seconds its off and on but mostly on so far. I take it that the fixings are still in the process though.
Image
User avatar
General laddida
 
Posts: 508
Joined: Mon Nov 19, 2007 11:25 am
Medals: 31
Standard Achievement (1) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (2) Freestyle Achievement (1)
Fog of War Achievement (2) Speed Achievement (2) Cross-Map Achievement (3) Ratings Achievement (3) Tournament Achievement (4)
Clan Achievement (7)

Re: UTF8 and Speedups

Postby jammyjames on Thu Oct 29, 2009 10:12 am

how come the scoreboard has changed too lack? there appears to be every user, both banned and not playing on the board, im down about 100 places, lol
Image
Corporal 1st Class jammyjames
 
Posts: 1247
Joined: Tue May 06, 2008 3:17 am
Medals: 46
Standard Achievement (3) Doubles Achievement (3) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (2)
Assassin Achievement (3) Manual Troops Achievement (3) Freestyle Achievement (3) Nuclear Spoils Achievement (2) Fog of War Achievement (3)
Trench Warfare Achievement (1) Speed Achievement (3) Teammate Achievement (2) Random Map Achievement (1) Cross-Map Achievement (3)
Ratings Achievement (3) Tournament Achievement (2) General Achievement (1) Clan Achievement (4)

Re: UTF8 and Speedups

Postby lackattack on Thu Oct 29, 2009 10:19 am

I fixed the scoreboard.

Unfortunately the database server is not entirely happy with these changes yet...
User avatar
Private 1st Class lackattack
Retired Administrator
 
Posts: 6235
Joined: Sun Jan 01, 2006 10:34 pm
Location: Montreal, QC
Medals: 9
Standard Achievement (1) Doubles Achievement (1) Triples Achievement (1) Freestyle Achievement (1) Speed Achievement (1)
Teammate Achievement (1) Cross-Map Achievement (1) General Achievement (2)

Re: UTF8 and Speedups

Postby laddida on Thu Oct 29, 2009 10:21 am

lackattack wrote:I fixed the scoreboard.

Unfortunately the database server is not entirely happy with these changes yet...



database servers think and have feelings? and will heal itself? :lol: sounds like an interesting server
Image
User avatar
General laddida
 
Posts: 508
Joined: Mon Nov 19, 2007 11:25 am
Medals: 31
Standard Achievement (1) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (2) Freestyle Achievement (1)
Fog of War Achievement (2) Speed Achievement (2) Cross-Map Achievement (3) Ratings Achievement (3) Tournament Achievement (4)
Clan Achievement (7)

Re: UTF8 and Speedups

Postby jammyjames on Thu Oct 29, 2009 10:32 am

laddida wrote:
lackattack wrote:I fixed the scoreboard.

Unfortunately the database server is not entirely happy with these changes yet...



database servers think and have feelings? and will heal itself? :lol: sounds like an interesting server


:lol: :lol: :lol:

thanks for the scoreboard fix lack...
Image
Corporal 1st Class jammyjames
 
Posts: 1247
Joined: Tue May 06, 2008 3:17 am
Medals: 46
Standard Achievement (3) Doubles Achievement (3) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (2)
Assassin Achievement (3) Manual Troops Achievement (3) Freestyle Achievement (3) Nuclear Spoils Achievement (2) Fog of War Achievement (3)
Trench Warfare Achievement (1) Speed Achievement (3) Teammate Achievement (2) Random Map Achievement (1) Cross-Map Achievement (3)
Ratings Achievement (3) Tournament Achievement (2) General Achievement (1) Clan Achievement (4)

Re: UTF8 and Speedups

Postby lackattack on Thu Oct 29, 2009 10:42 am

Turns out it was the scoreboard bug that was slowing things down! I guess even the database server doesn't want to see maxatstuy as Conqueror :lol:

I forgot to mention this fix:

  • Game finder searches for specific maps are now much faster.
User avatar
Private 1st Class lackattack
Retired Administrator
 
Posts: 6235
Joined: Sun Jan 01, 2006 10:34 pm
Location: Montreal, QC
Medals: 9
Standard Achievement (1) Doubles Achievement (1) Triples Achievement (1) Freestyle Achievement (1) Speed Achievement (1)
Teammate Achievement (1) Cross-Map Achievement (1) General Achievement (2)

Re: UTF8 and Speedups

Postby jammyjames on Thu Oct 29, 2009 10:43 am

lackattack wrote:Turns out it was the scoreboard bug that was slowing things down! I guess even the database server doesn't want to see maxatstuy as Conqueror :lol:

I forgot to mention this fix:

  • Game finder searches for specific maps are now much faster.



once again thanks, lol

haha lack makes jokes :lol: :lol: way to make my day with that 1
Image
Corporal 1st Class jammyjames
 
Posts: 1247
Joined: Tue May 06, 2008 3:17 am
Medals: 46
Standard Achievement (3) Doubles Achievement (3) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (2)
Assassin Achievement (3) Manual Troops Achievement (3) Freestyle Achievement (3) Nuclear Spoils Achievement (2) Fog of War Achievement (3)
Trench Warfare Achievement (1) Speed Achievement (3) Teammate Achievement (2) Random Map Achievement (1) Cross-Map Achievement (3)
Ratings Achievement (3) Tournament Achievement (2) General Achievement (1) Clan Achievement (4)

Re: UTF8 and Speedups

Postby pimphawks70 on Thu Oct 29, 2009 10:47 am

Thanks lack
Image
User avatar
Brigadier pimphawks70
 
Posts: 1106
Joined: Fri Aug 31, 2007 10:21 am
Medals: 77
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (4) Quadruples Achievement (4) Terminator Achievement (3)
Assassin Achievement (3) Manual Troops Achievement (4) Freestyle Achievement (4) Nuclear Spoils Achievement (3) Fog of War Achievement (4)
Trench Warfare Achievement (1) Speed Achievement (4) Teammate Achievement (3) Random Map Achievement (1) Cross-Map Achievement (3)
Ratings Achievement (3) Tournament Achievement (21) General Achievement (3) Clan Achievement (1) General Contribution (1)

Re: UTF8 and Speedups

Postby laddida on Thu Oct 29, 2009 10:50 am

sweet
Image
User avatar
General laddida
 
Posts: 508
Joined: Mon Nov 19, 2007 11:25 am
Medals: 31
Standard Achievement (1) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (2) Freestyle Achievement (1)
Fog of War Achievement (2) Speed Achievement (2) Cross-Map Achievement (3) Ratings Achievement (3) Tournament Achievement (4)
Clan Achievement (7)

Next

Return to Announcement Archives

Who is online

Users browsing this forum: No registered users and 2 guests

Login